Table Details not in Build

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

Guest

I would like to use the value of a combo box on a form as criteria, and it
isn't working. I tried to build the criteria and the details of the form
don't show up. I tried saving the form, restarting access and nothing seems
to be working.
When I leave the criteria out I get all the records.
Any Help would be greatly appreciated.
Thanks in advance
Ken
 
The query criteria should look something like:

[Forms]![FormName]![ComboBoxName].[value]

Sometimes you need the value on the end.

Also the from must remain open. You can hide the form with something like
this on the On Click event of a button on the from if you are using one to
fire off the query:
Me.Visible = False

Lastly the value of the combo box is taken from the left most column of what
is displayed. If you really don't want to see that value in the combo box,
you can change the first column width to 0.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query relelated to 2 combo boxes 2
Access Dcount (multiple criteria) 3
Default Query Criteria 1
Expression for Criteria for Form with Combo Boxes 1
multiple criteria 4
Query by form with 3 parameters 1
Blank fields 3
How To Specify No Criteria 2

Back
Top