List Box Query

  • Thread starter Thread starter AJF
  • Start date Start date
A

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
 
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!
 
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)
 
Back
Top