Value change in sub-form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form for orders with the products ordered in a sub-form. The users
enter a product ID to identify the products in the order.

I want to look for a change in the product ID, so that I can treat a change
in the product differently to no change in the product. I thought I could
store the old value somewhere, but can't get this to work either as a
variable in the form, or in a temporary table.

Any ideas would be welcome!

Thanks

Geoff
 
Hi,




Copy the data into a temporary table. Use the temporary table as source for
your form. Compare the temp table with the original table to detect changes.


Hoping it may help,
Vanderghast, Access MVP
 
Thanks for your input. I got round the problem by using the OldValue for the
field.

Best wishes,

Geoff
 
Hi,


Note that the OldValue is valid only for the actual record and is re-written
by the new value upon saving the record (or moving to another record). You
cannot relay on OldValue if you want make checks for MORE THAN ONE record,
the actual record.


Vanderghast, Access MVP
 
Back
Top