J
jim
I'm having a problem trying to set a value for a field in
a form using the SetValue function in a Macro. I'm working
with a form that has 4
fields, "DonationDate", "Amount" "MembershipCategory", "Cat
egory". I'm trying to set the Membership Category to take
on the value of the Category field, which is calculated
based on the Amount field. Here is the weird part. It only
works when I put in a date in the DonationDate field that
is prior to 2002. For example, if I type a donation date
of 1/1/2000, an amount of $50, the Category field
calculates the value properly and that value is also
automatically entered into the MembershipCategory field.
However, if I use the date of 10/10/2003 with all else
being equal, everything works except the
MembershipCategory field is not updated. The macro is
specifically designed to update that field and there is
nothing about the date in the macro. I should also mention
that the data entry is being done using a subform. Any
ideas?
a form using the SetValue function in a Macro. I'm working
with a form that has 4
fields, "DonationDate", "Amount" "MembershipCategory", "Cat
egory". I'm trying to set the Membership Category to take
on the value of the Category field, which is calculated
based on the Amount field. Here is the weird part. It only
works when I put in a date in the DonationDate field that
is prior to 2002. For example, if I type a donation date
of 1/1/2000, an amount of $50, the Category field
calculates the value properly and that value is also
automatically entered into the MembershipCategory field.
However, if I use the date of 10/10/2003 with all else
being equal, everything works except the
MembershipCategory field is not updated. The macro is
specifically designed to update that field and there is
nothing about the date in the macro. I should also mention
that the data entry is being done using a subform. Any
ideas?