Combo box to select text box data

uplink600

Registered User.
Local time
Today, 00:45
Joined
Mar 18, 2004
Messages
69
Hi

I have a table in my database with customer records including account number and account name. On a form I would like to set up a combo where the account number is selected and for the corresponding account name to appear in an adjacent text box.

The customer account number control is currently a textbox for manual entry but I want to change that to a combo with the AccountNumber field set as the control source.

I would like to know how to get the customer name to appear in the CustomerName textbox when the account number is selected from the new combo.

Any help would be appreciated and I enclose a copy of the form on a word doc.

Thanks

VC
 

Attachments

Users who are viewing this thread

Back
Top Bottom