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.
 
Back
Top