Updating Multiple Fields based on entry in another

[poohbear2012]

Hi

I have created a form for users to enter details about customers. I want the form to search the tblcustomerdetails table upon entry of the customer number into the first field and populate the first name, surname and date of birth fields if there is a value in that table that matches.

If there are not matches present they will need the ability to enter the form normally.

Is there any way of creating an AfterUpdate Event to undertake this?

Regards
Trisha

 

[MStef]

Do this via COMBO BOX.
Look at "DemoComboB3A2000.mdb" (attachment, zip).
Open form and try.

 

[poohbear2012]

A combo box is not a viable option for this as the options would end up exceeding the 255 limit allowed for the combo box.