neileg
AWF VIP
- Local time
- Today, 15:43
- Joined
- Dec 4, 2002
- Messages
- 5,975
Yes, that's what I meant. I presume you have six fields in the combo box, ID plus 5 address lines.
So on your form have the combo box set as line 5, with the ID column and columns 3 to 6 set to zero width so they are invisible. Place 4 text boxes under the combo and in the datasource put =Me.MyComboBoxName.Column(X) where X is the number of the relevant column in the combo. Note that the column number is zero based, so the first column is 0, the second is 1 and so on.
So on your form have the combo box set as line 5, with the ID column and columns 3 to 6 set to zero width so they are invisible. Place 4 text boxes under the combo and in the datasource put =Me.MyComboBoxName.Column(X) where X is the number of the relevant column in the combo. Note that the column number is zero based, so the first column is 0, the second is 1 and so on.