Combo question?

[Guest]

I want 2 combo boxes on a form. When I select an option in the first one, I
want only the linked info available in combo 2. Then comes the tricky part to
me anyway. I then want 4 text boxes to populate based on my combo 2
selection. I can get either to work but when I try and combine them, it's
doesn't work. I have info in each row source of each one which includes combo
box 2 as the row sourse for each. Can I combine the row sources? Please help

 

[John Nurick]

One approach is to include the values for the four textboxes as
additional columns in the RowSource of the second combobox. Use the
combo's ColumnWidths property to set the widths of these columns to 0.
Then just put code in the combo's AfterUpdate event to set the four text
boxes to the values of the relevant columns in the combobox, e.g.

Me.txtXXX.Value = Me.cboSecond.Column(2)

Another is leave the combobox as it is, and use DLookup() calls in its
AfterUpdate event to look up the value needed for each textbox.

On Tue, 15 Mar 2005 08:25:06 -0800, "combo boxes" <combo