Retain data in table based on changed data in another table

[James]

Using MS Access 2000 how do I retain boolean values
following changes to those values at a later date? ie if I
link a checkbox control in a form linked to the value in
another form and subsequently change the parent boolean
setting how do I keep the checkbox boolean value after the
parent value has been changed? I want to retain the
boolean value at a particular time and prevent it changing
later if I have to change the parent table or form's
value....

 

[John Vinson]

Using MS Access 2000 how do I retain boolean values
following changes to those values at a later date? ie if I
link a checkbox control in a form linked to the value in
another form and subsequently change the parent boolean
setting how do I keep the checkbox boolean value after the
parent value has been changed? I want to retain the
boolean value at a particular time and prevent it changing
later if I have to change the parent table or form's
value....

Then you'll need another table (perhaps with a timestamp indicating
when it was changed). Forms are just windows, and data on a form has
no permanent existance unless it's stored in a table.

What are the Recordsources of the two forms? Do you have a history
table already? If so, you'll probably want some VBA code in the
checkbox's AfterUpdate event to store the value and timestamp.

 

[James]

Thanks John - that's the conclusion I had come to - I'll
have to research the timestamp issue - I toyed with the
idea of creating date fields, but that didn't appear to be
a viable solution.

Cheers,
James

 

[John Vinson]

Thanks John - that's the conclusion I had come to - I'll
have to research the timestamp issue - I toyed with the
idea of creating date fields, but that didn't appear to be
a viable solution.

A Date/Time field (set to Now() ) should work fine - I was using the
term timestamp generically, not as a reference to the Timestamp
datatype. The latter is available in SQL/Server but not in JET (Access
..mdb) databases.