type number and name appears

[realflava]

I have 2 tables - Customer and Visit Details

The Visit Details has two fields related to the tblcustomer:

Cust No.
Name

What I'm trying to implement is: when the user types in the cust no. the name should appear.

Any ideas how I can do this?

Thanks

 

[scriverb]

Try using the ComboBox control Wizard. This Wizard will walk you through one of the options where as you enter the name or pick from the box then the record is found and the fields on the form are automatically populated with the data from that record.

I think this will work well for your problem.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[KenReay]

hi

one small point:

you say

"The Visit Details has two fields related to the tblcustomer:

Cust No.
Name "

presumably the (Customer) Name is in the Cutomer table, why repeat it in the VisitDetails Table?

oops another point, do not use reserved words (such as Name) as column names, it will end in tears

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[realflava]

Thanks for that Bob! I feel soo dumb sometimes..