Help using listbox to pass criteria to query

[wesley.allen]

I admit first that I am not very good using SQL. I am new to Access,
but I am trying to pass a selection in a list box as criteria for a
query. This list box is set to Multiselect "None", so I only need to
pass a single selection to the query. The list box is populated with
months from a table saved as "Month Table". I need to pass the
selection to a query and return all items that occur in that month.
Can anyone help.

Thanks.

 

[Douglas J Steele]

Have you query use Forms!YourFormName!YourListboxName as its criteria.

(Change YourFormName and YourListboxName to the correct names)

 

[SusanV]

Hi Wesley,

In a stored query, set the criteria to the form's control:
[Forms]![YourFormsName].[YourListBoxName]

If the listbox is on a subform, it's a bit more complex, see this website
for more info:
http://www.mvps.org/access/forms/frm0031.htm

 

[wesley.allen]

Thank you. I have tried this, but my query dows not return any
results. I have added a button created from the toolbox and this
executes the query after I make my selection. It is set to open query.
I assume this is what is making this not work. Any suggestions?

Thanks,

Wes

 

[SusanV]

If you do NOT select something in the listbox, you should see all records in
this query - does that work?