Build an AutoLookup query in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
You can make a subform on a main form that will automatically update the key
field when data is entered into the subform.
 
Back
Top