Open a drop down on the basis of two options checked

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

There is a radio button name Option934 and a check box name chk1Dtl11
in my form. I need help how to open a drop down when both are clicked.
Drop down contains only two values from table tblExplanation:

tblExplanation
DetailID ReasonID ExplanationID ExplanationDescr
11 1 1 Did not create a Remedy ticket
11 1 2 Falsified comments on the Remedy Ticket

DetailID is the key field

Thank You.
 
Hi Anna,

I'm not certain what you mean by "open a drop down". If you want to
select a combo box and drop its list, try putting this in the
AfterUpdate procedures of both Option934 and chk1Dtl11. I've called the
combo box cboXXX:

If (Me.Option934.Value = True) _
And (me.chk1Dtl11.Value = True) Then
Me.cboXXX.SetFocus
Me.cboXXX.DropDown
End If
 
Back
Top