AutoFull Form Fields after selecting master data

[ragu111]

i have a customer_master table with below fields

# Customer_name
# Tel_No
# Contact_name

and i have a Call_Record table/form which also got above 3 fields and some other fields

what i want is on the Call_Record Form once i select the Customer Name (by ComboBox) i want the other (Tel_No and Contact_Name) to be filled from the Customer Master.

Can someone help me to do this in my access project.

ragu

 

[PHV]

Have a look at the Column property of the ComboBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[stix4t2]

You can build the row source for the combo box and add all the fields you want to use in the form. Remember that you must set the column count and column widths.
i.e.
column count 3
column widths 2", 0, 0 'to hide values in dropdown
column widths 2", 1", 1" ' to show values in dropdown

Then add fields to the form. In the controlsource use
yourcomboboxname.column(1) to get the value from the combo box's second column, 0 is the first.

Good Luck