autofill multiple fields based on selection

[Guest]

I have a table that stores bank account info. When the user selects the bank
account # I need the rest of the bank details to autofill on my main form.
The table is:

Tbl_Account_Details with the following fields:
Account_ID
Bank (looks up bank from Tbl_Bank)
Account_Holder (looks up from Tbl_Acct_Holder)
Account_Type (looks up from Tbl_Acct_Type)
Account_Number
US_Acct (yes/no field)

I set up a drop down in my Tbl_Main to select the Account Number (they see
all fields but the acct # is stored for the record Main_ID). When the acct #
is selected, I need the remaining fields regarding the account to autofill on
my main form. Not sure if I need some kind of subtable/subform or can
otherwise make it fill in the fields. Any help is greatly appreciated -
thanks in advance!!!!

 

[Guest]

You usually use an unbound combo box for this purpose. The combo box wizard
will help you set this up.

 

[Guest]

Thanks Klatuu - when I try this it doesn't work because it only allows me to
select the account number which is the data I'm storing in the main table.
Would it be best to set up a subform and should this query the Bank Detail
table?

 

[Guest]

I don't see why you need Tbl_Account_Details. That is the sort of thing you
do with a query. I also don't understand the need for a subform. Perhaps
you could post a bit more detail on what you are trying to do.

 

[Guest]

Hi Again,

The Main table contains info regarding properties owned. For each property
there will be a bank account that is used. There are many different bank
accounts and companies. The Tbl_Account_Details includes all the bank
account information (my fields listed below). For example:


In my Main Table, I have a drop down for Account where the look up column
shows all the fields from Qry_AccountDetails (which is based on
Tbl_Account_Details). They can select the account from there however, I
cannot figure out how to make each field show up on the form - if they select
Account_ID 1 I would like each of the other fields listed above to
automatically show up but I'm not sure how. Does this provide you enough
info?

 

[Guest]

I am back to my original answer. I think perhaps the reason you are having
difficulty is the combo is a bound control. A combo used for a search should
not be a bound control.
If you are using lookup fields defined when you built the table, you should
abandon that idea. It creates more problems than it cures.