Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gary Costigan
Yak Posting Veteran
95 Posts |
 Posted - 2003-10-08 : 16:45:16
|
| I have built a form and in one area I have placed a "Check Box".When checked the box takes me to another form which the viewer needs to fill out. Everything works fine to this point.My question is this. If we go back later to update the original form and "UnCheck" the check box, the new form pops open again. Is there a way of turning this feature off or adjusted so that the new form will "only" open when the box is originally "checked" and not when it's unchecked?Thanks.GC |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-08 : 19:53:43
|
| Yes. How are you triggering the opening of the window in the first place? In a onChange action? Wherever it is, hopefully you're using VBA (module) code and not macro code to do it. You'll have more control in VBA. Then, before you open the second form, just do a test on the value of the checkbox. If it's TRUE, open the form, otherwise don't.--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
 |
|
|
jhermiz
3564 Posts |
Posted - 2003-10-25 : 23:01:04
|
On Click Event:If Me.chkBox.Value then DoCmd.OpenForm "frmMyForm"else 'do not open the formend if |
|
|
|
|
|
|
Access Check Box