Setting a value to a different field based on current field

[Paul]

I'm trying to set the value of a yes/no box based upon the value enterend in
the YTDOrders field on a form. The name of the yes/no box is
PreferredCustomer. If the value is < $10,001 I do not want the yes/no box to
be checked. If the value is > $10,000 I want the PreferredCustomer box
checked. I tried doing this in a macro but could only get the box to be
greyed out if the conditions were met or not greyed out for the then part.
Any help would be greatly appreciated.

I used to use SetValue in Access 2000 but am now using 2007 and that command
isn't available in a macro.

 

[ruralguy via AccessMonster.com]

Have a look/see here:
http://www.btabdevelopment.com/main...dallofthemacroactionsgo/tabid/83/Default.aspx

 

[Paul]

I solved this problem with a MACRO...I found the SetValue action and was able
to make it work.

 

[ruralguy via AccessMonster.com]

Great! Thanks for posting back with your success.

I solved this problem with a MACRO...I found the SetValue action and was able
to make it work.

I'm trying to set the value of a yes/no box based upon the value enterend in
the YTDOrders field on a form. The name of the yes/no box is

[quoted text clipped - 6 lines]

I used to use SetValue in Access 2000 but am now using 2007 and that command
isn't available in a macro.