Automatically entered data

[helen_baker]

Hi, was wondering if anyone could help me,


I have created a form to input customer information which is linked to my customer table. In the form, I want to be able to enter the name of the customer and for the address, phone number etc to be entered for me automatically. Can anyone show me how to do this please?

[June7]

You have a table of address records? So what you need to do is select the ID of the address record from a combobox bound to Address field in customer table. Displaying the related address info can be done in the combobox or in textboxes that reference the combobox columns or by joining to the address table in the form's RecordSource.