Using a ListBox selection to query a database

[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

[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,
--
Gary Brown
gary_brown@ge_NOSPAM.com
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