I would like to have a form with a lookup that then displays the results in a sub form.
The Master form is created and the Record Source is a query, the Subform is created and the record source is a different query. The parent link master field and the child fields are linked. This form works when a search is performed or one scrolls through the records.
What we would like to do is change the control named customer code to allow a user to type in the customer code and then tab or hit a button that would then move to the correct record (just like the search at the bottom of the Master form.