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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Contents of a drop down box based on the selection in another drop 1
Command buttons tied to the form 2
Filtered drop down list 2
VBA code to select website drop down opion 0
Frontpage 2000 - Going to a new page from a value in a drop-down box 0
Finding the right record with a drop down list 1
Searching a Table on a Form Using Drop Down Text Boxes 3
How to filter out the same values in the drop-down list of a combo 5

Back
Top