Setting a value to a different field based on current field

  • Thread starter Thread starter Paul
  • Start date Start date
P

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.
 
I solved this problem with a MACRO...I found the SetValue action and was able
to make it work.
 
Back
Top