Open form and filter records by using a combo box

[Guest]

Currently I have a switchboard with a command button that runs a query with a
parameter to enter a review number and then a second form opens showing only
those records with the matching review number. The problem is, you must know
before hand which review numbers are listed in the table.

How can I use a combo box to show all review numbers in the table and then
once the appropriate review number has been selected, the second form opens
with all records that match the review number selected from the combo box?

 

[Guest]

Set the data source for your combo box on the first form (Form1.cmbSelect) =
"Select review_number from tablename". When the second form opens, have
it'its data source filter on Form1.cmbSelect.Value. This can be done in a
second query as the datasource for the second form, or as a filter on the
form itself.