Question on Automation

[jk]

I am designing an Expense DB and in my Accounts table i have 20 unique
account numbers. There is also a decription for each account number in which
i would like to associate with the respective account number since in my
Forms design i would have a list box selection in which a user can pick a
description and the account would fill in the field. Is this done with a
Macro?

 

[Duane Hookom]

I think you are describing a basic combo box bound to the account number field.

 

[jk]

Yes. How do you go about this since in the user form that will be created, I
will hide the account number field but display the account description so the
user just picks a description which would then automatically fill in the
field for the associated account number.

 

[Duane Hookom]

You might want to check the sample Northwind where this is used on most forms
where a user selects an employee or product or customer or ... while viewing
the "text" values but actually storing the primary key field values.

If this doesn't help, come back with some significant table and field names
and data types.