combo box to Populate a form

[rcappy]

Hi all
I have 2 forms generated from 2 tables


1 customer
1 orders
I have a drop down box in the orders form which contains customer ID and surname,address 1, address 2, county , postcode and tele number. from customer details and can only fill in the surname in the orders form.

How can I populate all the other fields on the order form?

[Bob Fitz]

You could set the Record Source property of each text box to something like this:

= Nz(NameOfCombo.Column(NumberOfColumnRequired),"")

The <NumberOfColumnRequired> part should be the number of the column that holds the detail required. Keep in mind that column numbers start from 0, so the first colum is number 0, the second is number 1 etc.

This is Untested