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

S

Steve Schapel

Rickster,

This is an unusual request. I guess the key point here would be *when*
do you want this to happen?
 
R

Rickster172

I want this to happen on a command button to setup a control for the current
record.
 
S

Steve Schapel

Rickster,

So you want to click a command button to tick a checkbox? Why not just
click the checkbox directly?
 
R

Rickster172

Because I want the button to do it because that record is the record I want
to print. The Yes/no fieild is invisible.
 
S

Steve Schapel

Rickster,

Ok. Now I understand! :)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to change Yes/No checkbox to No when exiting record 5
Copy previous record into form field 0
Yes/No pop-up 1
Yes/No Condition 7
viscual basic code Me.control="Yes". How do it with a macro? 1
MSgBox Yes No 5
Set Display Control for a Table Yes/No Field 5
Macro to change a field from Yes to No 3

Top