Form display based on item selected

[texasalynn]

I have a form that has a combo box that a user can select an item. What I want is after they make their selection I want it to show a name for what they selected.

For example the combo box has a a list of account number, so if they select #14 a text box would show the customer name - ABC Company. I'm sure I need to enter something in the event for "On Enter" but I have no idea how to write code.

Thanks ... texasalynn

 

[Ziggy]

I'll first ask a dumb question if you have the account number is the account name not also part of the same table?

At any rate the two are related somehow, i would assume then in separate tables. If this is the case create a query(union/join) with both tables then use the query as the control source to your form instead. This will work but give more details if it doesn't.

List your fields for each table.


Ziggy

 

[NitherWise]

You could also use the DLookup function.