go to record based on combobox selection

[Thymus]

Hi all,

it's easy to set up a form with a combobox that will list all records and moves the user to the selected record. But I can't figure out how to just show a selection of the records in this combobox, instead of all records.

So, to use the example used in most online tutorials: a drop down menu shows you all the names in a customer database. However, I'd like to have instead a dropdown menu with an overview of all surnames in the database and that I move to the first record with the selected surname.

Thanks in advance for helping out.

 

[llkhoutx]

On the combo box AfterUpdate event rebuild the form record source or the form filter and filter on properties. Those properties should be initialized on the form OnOpen event.