Has anyone any idea how to open a form in VBA based upon an If statement??? Basically I want to open a form when I get a certain answer in a combo box! I have no probs opening a form after updating a text box but I cannot limit it to only open when a certain answer is given! ANY IDEAS?????????
A Very taxing Problem!
- Thread starter DJ100
- Start date
jimbrooking
Registered User.
- Local time
- Today, 09:03
- Joined
- Apr 28, 2001
- Messages
- 210
OK, say you have a combo box called cboGuessTheNumber that has a Row Source Type of ValueList, and a Row Source of 1;2;3;4;5.
In the AfterUpdate event for cboGuessTheNumber, choose [Event Procedure] and click the build [...] button. In the space between the "Private Sub..." line and the "End Sub" line type
If me.cboGuessTheNumber= 4 then docmd.OpenForm "frmYouWin"
(The number 4 is the "winner", and if the user selects it, the form named frmYouWin will be opened.)
In the AfterUpdate event for cboGuessTheNumber, choose [Event Procedure] and click the build [...] button. In the space between the "Private Sub..." line and the "End Sub" line type
If me.cboGuessTheNumber= 4 then docmd.OpenForm "frmYouWin"
(The number 4 is the "winner", and if the user selects it, the form named frmYouWin will be opened.)
