I have a table, and there are many records, each with a unique value in the OrderNumber field


I have a text box on a form, and i want it to work so that the user types in a OrderNumber value, and it loads that record into the form (the form is bound to the table)


I already know how to load a record by record number, but how can i do it by OrderNumber value?



thanks

If you use a ComboBox (with the Wizard) you can select Option3 "Find record based on the value etc"

Then the user can type in part of the value and then select from the dropDown list. The form should populate with the matching record.

Col