ACCESS - PARAMETER QUERY WITH COMBO BOX

I am confused.  I thought that if I created a parameter query and a combo box form I could run the query and it would pop up the form with the dropdown choices in the form for the user to pick from.  

I have this written in the criteria: [forms]![CATEGORIES FORM].[CategoryName]

What am I doing wrong?

HELP!
MLW


MLWilhelmyAsked:
Who is Participating?
 
mbizupCommented:
In otherwords, the query itself will not open your form.
0
 
mbizupCommented:
You need to start with  CATEGORIES FORM open, and some value in CategoryName.

Then when you open your query, the values of that field will be restricted to CategoryName as specified by the user in your form.
0
 
wiswalldCommented:
Not quite sure what you are trying to do. Sounds like you are doing this backwards. You should be basing the combobox on the query not the other way around.
0
 
TaeSoftCommented:
Here's how to load unique names from a persons table into a combo box (in MsAccess)

Combo1.Requery = "select distinct name from persons"

But I think mbizup is right and you're doing it the other way around.

A query is a staement to fetch data not to open a form and fill a combo.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.