Using a ListBox selection to query a database

C

CLamar

I am creating a User Interface in Excel that will query tables in Access. My
first Access query places the data into a ListBox, from that list box the
user will need to be able to query the database again for the selection he
chose from the listbox. (Simply put I am trying to imput the ListBox
selection into the SQL statement to query the database again) Does anyone
have any suggestions on how to accomplish this.

Thanks
 
G

Gary L Brown

Build the query using the value from the listbox.
ie:
Dim strValue as string, strSQL as string
strvalue = ListBox1.value

strSQL = ..... & strvalue & ....
HTH,
 
Top