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

 

[AncientOne]

You could make your combo show more than one column. Is this account number the primary key for the table that shows the company name?

Another approach is to make the combo select the record you want on a form. There is a wizard to guide you through this.

 

[cominapart]

texasalynn, an article on Microsofts knowledge base may help.

article id 319482.