How to setup a macro to change current record yes/no field to Yes?

  • Thread starter Thread starter Rickster172
  • Start date Start date
Rickster,

This is an unusual request. I guess the key point here would be *when*
do you want this to happen?
 
I want this to happen on a command button to setup a control for the current
record.
 
Rickster,

So you want to click a command button to tick a checkbox? Why not just
click the checkbox directly?
 
Because I want the button to do it because that record is the record I want
to print. The Yes/no fieild is invisible.
 
if the checkbox is called 'checkBox' you could put the following code on the 'On Click' event of the command button;
Me.checkBox = -1
​
then when you click the command button, checkBox is updated with a tick, is that what you mean?
 
Rickster,

Ok. Now I understand! :-)

It should work to use a SetValue action in your macro, with these arguments:
Item: [NameOfYourYesNoField]
Expression: Yes
 
Back
Top