Filtering records with a combo box

[SteveH]

I have a form with some data on it. I would like to be able to click on a
combo box and filter records, ie go to the record selected. Any suggestions
would be appreciated.

Thanks

 

[fredg]

I have a form with some data on it. I would like to be able to click on a
combo box and filter records, ie go to the record selected. Any suggestions
would be appreciated.

Thanks

Add a combo box to the Form's Header using the Combo Box Wizard.
Select the 3rd option on the first page of questions, something like
"Find the record .. etc..".
Continue with the wizard. When done, select the value in the combo box
that you wish to see and the form will display that record.
This combo box should not be bound to any field in the table.

 

[SteveH]

That works perfectly. Thanks

Add a combo box to the Form's Header using the Combo Box Wizard.
Select the 3rd option on the first page of questions, something like
"Find the record .. etc..".
Continue with the wizard. When done, select the value in the combo box
that you wish to see and the form will display that record.
This combo box should not be bound to any field in the table.