Write to 3 combo boxes based on choice in 1st Combo Box 
Author Message
 Write to 3 combo boxes based on choice in 1st Combo Box

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?



Wed, 02 Mar 2005 03:34:41 GMT  
 Write to 3 combo boxes based on choice in 1st Combo Box
You do it pretty much the same way, except you want to reference the Column
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


Quote:
> 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?



Wed, 02 Mar 2005 03:59:38 GMT  
 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?

>.



Wed, 02 Mar 2005 04:47:12 GMT  
 Write to 3 combo boxes based on choice in 1st Combo Box
It goes into either the VBA code, or your query criteria, depending on what
exactly you are doing.  How are you getting the value into the first combo
box?


Quote:
> 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?



Fri, 04 Mar 2005 20:48:13 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Limiting combo box choices based on the previous combo box

2. Requerying 2nd combo box after change to 1st combo box

3. auto populate text box based on combo box choice

4. combo box list based on the selection in another combo box

5. Set value in second combo box based on first combo box

6. populating a combo box based on selection in another combo box

7. Combo Box based on another Combo Box.

8. Combo box list that changes based upon another combo box

9. Content of a Combo Box based on result of other Combo Box

10. VBA Combo Box, how to fill based on first combo box selection


 
Powered by phpBB® Forum Software © phpBB Group