Unanswered: Creating queries - recordsets in code
I am fairly new to Access but have done a fair bit of VB in the past. I have a form in Access which has lists of info on it. The choice in the first list will select records for the second list; however I need to query the choice in the first list twice and use information from both results to build the last query.
I have, with help from another forum member, got the query side of things sorted out by creating quires in access with e.g.: [DEPARTURE POINT?] and this bringing up a dialog, and then typing in the criteria in to the dialog for the query to use, but now want to let my user choose from lists on my forms.
What is the best way to tackle this?
the light is on, someone is home, but they dont know they are. HELLO!