M
Maurita
Hi, I need help automatically filling in a combo box (Combo2) from the
choice I make from another combo box (Combo1). The choice in Combo2 is
not related to Combo1, but is dependent upon the choice from Combo 1.
When the user chooses "Production" from Combo1, I need the cursor to be
placed in Combo2 and to either choose the "Productive" choice from
Combo2 or to have "Productve" automatically filled in Combo2. The
following code shows the cursor going to Combo2, but I can't figure a
way to fill in Combo2 with "Productive" when "Production" is chosen
from Combo1. Since there are multiple choices for "Downtime", I just
need to get the cursor to the combo box and let the user choose from
the list, which the following code does. I am only having trouble if
the user chooses "Production" from Combo1 because "Productive needs to
be automatically filled in Combo2. I appreciate any ideas. Thank you.
Maurita Searcy
If Me!Combo1 = "Production" Then
DoCmd.GoToControl "Combo2
ElseIf Me!Combo1 = "Downtime" Then
DoCmd.GoToControl "Combo2
End If
choice I make from another combo box (Combo1). The choice in Combo2 is
not related to Combo1, but is dependent upon the choice from Combo 1.
When the user chooses "Production" from Combo1, I need the cursor to be
placed in Combo2 and to either choose the "Productive" choice from
Combo2 or to have "Productve" automatically filled in Combo2. The
following code shows the cursor going to Combo2, but I can't figure a
way to fill in Combo2 with "Productive" when "Production" is chosen
from Combo1. Since there are multiple choices for "Downtime", I just
need to get the cursor to the combo box and let the user choose from
the list, which the following code does. I am only having trouble if
the user chooses "Production" from Combo1 because "Productive needs to
be automatically filled in Combo2. I appreciate any ideas. Thank you.
Maurita Searcy
If Me!Combo1 = "Production" Then
DoCmd.GoToControl "Combo2
ElseIf Me!Combo1 = "Downtime" Then
DoCmd.GoToControl "Combo2
End If