G
Giz
Hi,
Is there a visual basic command/language to run a query without having it
open in access? What I am doing is picking items from a list box in a access
form, then "On Exit" calling an event procedure in vb that creates a query.
From this query I would then like to populate a second list box. The problem
is, I can't figure out how not to open the query in access, I would just like
to create it and run it. Right now, my vb procedure has an "OpenQuery"
command to in effect run the query. Is there a "RunQuery" type command that
won't open it as well??
Is there a visual basic command/language to run a query without having it
open in access? What I am doing is picking items from a list box in a access
form, then "On Exit" calling an event procedure in vb that creates a query.
From this query I would then like to populate a second list box. The problem
is, I can't figure out how not to open the query in access, I would just like
to create it and run it. Right now, my vb procedure has an "OpenQuery"
command to in effect run the query. Is there a "RunQuery" type command that
won't open it as well??