Posted on 2007-07-24
Last Modified: 2008-02-01
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?


Question by:MLWilhelmy
    LVL 61

    Expert Comment

    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.
    LVL 61

    Accepted Solution

    In otherwords, the query itself will not open your form.
    LVL 13

    Expert Comment

    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.
    LVL 2

    Expert Comment

    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.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now