Write to 3 combo boxes based on choice in 1st Combo Box
i realize i'm being dense,
but i'm not seeing where the Me.ComboBox1.Column(1)
reference would go?
If i click on the properties of the combo box, i'm not
seeing an appropriate spot for this reference?
Or does the Me.ComboBox1.Column(1) go into vba code and i
reference that?
Quote:
>-----Original Message-----
>You do it pretty much the same way, except you want to
reference the Column
Quote:
>property of the combobox. (Note: Column is zero-based.)
So, you would
>reference it as:
>Me.ComboBox1.Column(1)
>for the second column. By default, it will look at the
selected row.
>HTH,
>Marshall Smith
>> I have a form for entering payment information in a
>> payments table.
>> In addition to payment info, i need to capture Manager,
>> ProjectID & ProjectName.
>> The 1st combo box (Manager) displays thru a query all 3
>> items needed for the above combo boxes. The idea is for
a
>> person to select the right Manager-ProjectID-ProjectName
>> combination and write to all 3 combo boxes.
>> How do I write to all 3 combo boxes based on the
recordset
>> picked in the 1st combo box?
>> For example, if the user picks Mgr_A, ProjectID_1 &
>> ProjectName_ABC within the 1st combo box, I write Mgr_A
in
>> the 1st combo box, but I also want the other 2 combo
boxes
>> to 'automatically' populate with ProjectID_1 and
>> ProjectName_ABC.
>> How to accomplish?
>.
