[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1088
  • Last Modified:

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


0
MLWilhelmy
Asked:
MLWilhelmy
  • 2
1 Solution
 
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
 
mbizupCommented:
In otherwords, the query itself will not open 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

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now