One contact - 3 contact types

[skelley]

I have one set of contacts in a table. These contacts consist of 3 types (1) Ship To, (2) Bill To, and (3) End User. Sometimes the same contact is ALL Three and sometimes it takes 2 or even three contacts to complete the form.

My form is based on a query that allows the user to select one of these contacts for each of the three types.

How can I get the address information, etc., to fill in automatically when the user selects a contact name?

 

[DML]

There are a few ways to do this, here is one...

In the row source of your Contacts combo box (I assume your contact's are in a combo box because you said the user selects a contact), you can include the address information. On the format tab for the combo box, make sure your column count is set to the number of columns you have put in the row source. If you do not want to look at all of those columns in the list, set the column widths property (for example -- column count = 4; column widths = 0";1";0";1" --> this will show only the 2nd and 4th columns of the four in the list) On the after update of the Contacts combo box, you can refer to the other columns like this

me.[contactscombo].column(2) where zero (0) is the first column, 1 is the second column, etc.