Combobox changes display records

  • Thread starter Thread starter afollo
  • Start date Start date
A

afollo

I have a form with a combobox (off course). When the user changes the value
of the combobox I want to display certain records. I know will need (or I
suppose) a Select query, which I already have, but how do I use it to
display only these particular records? Any example or code snipped I could
follow? I am pretty new to this so I don't know what the best approach would
be. Thanks
 
Afollo,

The general idea here is probably to use the value selected in the
combobox as a criteria in the query that the form is based on. The
syntax of the entry in the query criteria will be something along these
lines...
[Forms]![NameOfForm]![NameOfCombobox]
and this will go in the Criteria of whichever column in the query is the
date that the selection in the combobox will relate to.

Please post back with more specific details, with examples, if you need
more explicit help.
 
Back
Top