Value change in sub-form

G

Geoff D

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
 
M

Michel Walsh

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
 
G

Geoff D

Thanks for your input. I got round the problem by using the OldValue for the
field.

Best wishes,

Geoff
 
M

Michel Walsh

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
 
Top