Filtering records with a combo box

  • Thread starter Thread starter SteveH
  • Start date Start date
S

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
 
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
Click to expand...

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.
 
That works perfectly. Thanks

fredg said:
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.
Click to expand...
 
Back
Top