Access 2002 Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to know how to get a combo box for possible answers to a question I am
asking when I run a query...so that the user does not have to type in his
answer, just select it from a menu?...Thanks
 
Access lightweight <Access
I need to know how to get a combo box for possible answers to a question I am
asking when I run a query...so that the user does not have to type in his
answer, just select it from a menu?...Thanks
Click to expand...


Put the combo box on a form

Change the query's criteria from (Enter someth8ng] to
Forms!nameof form.nameofcombobox

Open the form and select an entry

Run the query
 
I must be doing something wrong. I made the form and put the proper syntax
in the criteris for the parameter i am trying to get a value for and it
simply changes the text in the box which is prompting me for a value, but no
combo box.

Marshall Barton said:
Access lightweight <Access
I need to know how to get a combo box for possible answers to a question I am
asking when I run a query...so that the user does not have to type in his
answer, just select it from a menu?...Thanks
Click to expand...


Put the combo box on a form

Change the query's criteria from (Enter someth8ng] to
Forms!nameof form.nameofcombobox

Open the form and select an entry

Run the query
Click to expand...
 
Access said:
I must be doing something wrong. I made the form and put the proper syntax
in the criteris for the parameter i am trying to get a value for and it
simply changes the text in the box which is prompting me for a value, but no
combo box.
Click to expand...


If the query is asking you to enter something, then it's
because the criteria is spelled wrong or the form has been
closed. The prompt tells you exactly what the query doesn't
understand.

If you can't find the typo, post back with the prompt along
with a Copy/Paste of the criteria, the name of the form and
combo box so I can take a look at it.
 
I must be doing something wrong. I made the form and put the proper syntax
in the criteris for the parameter i am trying to get a value for and it
simply changes the text in the box which is prompting me for a value, but no
combo box.
Click to expand...

The form must be open FIRST - Access won't open it for you!

It's convenient to open the criteria form first, and have a command button on
it to launch the report, or query, or other form as needed.

John W. Vinson [MVP]
 
Works great now...thanks so much for all of your help...I had the name of the
combo box wrong
 
Back
Top