List Box Criteria for Query

tca_VB

Registered User.
Local time
Today, 03:36
Joined
Jul 12, 2007
Messages
24
I have a query which is based off all fields of the main table. I want to run the query based on one or more choices made from a list box on one field: category.

tbl_ClientMain

qry_ClientCategory - all fields of tbl_ClientMain with criteria under Category as =[Forms]![frm_CategoryList]![lstCategory]));

frm_CategoryList is a listbox form based on qry_Category

qry_Category is a group by query from tbl_ClientMain of the Category(s) collected

When I run the query, I get Enter Parameter Value: Forms![frm_CategoryList]![lstCategory]));

Based on what I've read in various postings and other sources - I must be close, but I'm missing something. Any ideas?
 
Going by what you have written, it would appear that the
[Forms]![frm_CategoryList]!1stCategory] selection is not being accept as a parameter.
Go back and check you spelling in the search form and in the query to ensure they are the same.
 
I've double checked spelling and can't see anything wrong.

Do I need to set the Query-Parameter to something? I usually don't do that but needed to for something else.

I tried setting
[Forms]![frm_CategoryList]![lstCategory] to data type Text

But I get the same result, still looking for me to enter the parameter.
 
I'm reading other resources I can find online.

One says something about the ListBox form being open when you run the query. Is this true?

It mentioned something about putting a subform on the ListBox form that then runs the query. I tried to create a subform based on the query, but it would not give table/query options, only forms.

Does this help give anyone an idea of where I can head next? I'm really at a standstill.
Thanks!
 

Users who are viewing this thread

Back
Top Bottom