By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,510 Members | 1,821 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,510 IT Pros & Developers. It's quick & easy.

Open a drop down on the basis of two options checked

P: n/a
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.

Aug 22 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Option Compare Database

Private Sub Check9_Click()
If Me.Frame0.Value = 1 And Me.Check9 = True Then
Me.Combo11.SetFocus
Me.Combo11.Dropdown
End If
End Sub

Private Sub Frame0_AfterUpdate()
If Me.Frame0.Value = 1 And Me.Check9 = True Then
Me.Combo11.SetFocus
Me.Combo11.Dropdown
End If
End Sub
Yeah yeah, I could have put the stuff in a separate sub and called it
from each event. True.

you really should rename your controls. As you can see, Combo11
doesn't mean a whole lot when you're trying to debug a form with tons
of controls on it.

Aug 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.