Using a checkbox to change a button function

sentient_amoeba

Registered User.
Local time
Today, 11:17
Joined
Jul 21, 2003
Messages
10
Hi there

I'm trying to figure out how I can place a checkbox next to a button so that when the checkbox is checked, clicking on the button will open a new form.

If there is NO checkmark, then the button does it current function on that page.

Any suggestions? Thank you so much!! :)


"To do is to be"...Plato

"To be is to do"...Socrates

"Do be do be do"...Sinatra
 
sentient,

In the OnClick event for your command button:

Code:
If Me.NewCheckbox = True Then
   DoCmd.OpenForm ...
   Exit Sub
End If


Wayne
 

Users who are viewing this thread

Back
Top Bottom