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

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

strSQL = ..... & strvalue & ....
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"CLamar" wrote:

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