Build an AutoLookup query in a form

[Guest]

Fields Account Number and Account Name are in a table with Account Number
indexed and primary key. Another table has 10 account numbers identified as
Acct1, Acct2, etc, which are populated on a form by a combo box based on the
first table. I want to automatically populate the form and second table with
Account Name using the form. I have a one-to-many relationship setup. I found
information on what the AutoLookup does, but not how to do it in Help.

 

[[MVP] S.Clark]

You can make a subform on a main form that will automatically update the key
field when data is entered into the subform.