List Box Query

[AJF]

Hello,

I have a form with a list box for mutliple selections and
and OK button that runs a query pulling data from Oracle
11i. The user would like to select one or more selections
from the List Box to access certain data. Is there a way
to pass the list box into the criteria section of a query?

Thanks,

AJF

 

[Van T. Dinh]

Change your ListBox to Multi-Select and use the code from The Access Web
article:

http://www.mvps.org/access/forms/frm0007.htm

You probably need to modify the code in the above article to suit your Form
and your Oracle Back-End.

 

[AJF]

O.k. Does the Code get placed into a Module and called
up, or within the Form. I'm not sure where to place the
code. Either way, I get an error on the first line of
code:

Set frm = Form!Reporting (Object required?)

Thanks!

 

[Van T. Dinh]

You left out the "s" in Forms.

Try:

Set frm = Forms!Reporting

or:

Set frm = Forms("Reporting")

You can put the code in code module of the Form.

HTH
Van T. Dinh
MVP (Access)