can you please help me on how to search multiple data and display it to my datagrid. im a newbie in vb6 and im having a hard time in coding.

Recommended Answers

All 2 Replies

Create a dataset using a SQL statement to combine your multiple data and then use this as the recordsource for the datagrid.

thank you for replying Chris. i already did that and i use this code
"select * from tblflightschedule_roundtrip where Departure='" & cbofrom.Text & "' and Arrival='" & cboto.Text & "' and Flight_Date>=#" & DateValue(txtdep.Text) & "# and Returning_Date<=#" & DateValue(txtarrival.Text) & "#"

but when try to run it, an run-time error '13" Type mismatch happen. how can i solved this?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.