Using Macros in a Form

[sjphx]

I am creating an application in Access for a co-worker that will include
forms used for inputing data. To make the data entry easier, I am trying to
create a macro that will automatically create a drop down box of records that
correspond to the population of the first field in the form. The
corresponding records will come from another table in the database. For
example: she will input Account type in the first field, when she tabs to the
next field (Account Name) it will have a drop down selection of all Account
names that correspond to that Account Type (the Account Names will be from a
different table in the db. How do I do this?

 

[Van T. Dinh]

Perhaps, you should create a set of 2 cascaded ComboBoxes: the first one so
that she can select the AccountType and the second one shows the Accounts of
the Type selected in the first ComboBox.

See The Access Web article:

http://www.mvps.org/access/forms/frm0028.htm