Checkbox that records date of true

[mdemetri2]

Hello

 

Was wanting you know if anyone had come across a method whereby the following occurs:

 

On editing an existing record pulled back on a form, if a checkbox is change to TRUE (ticked) and then the record is submitted to update the database, then it should also record the date/time in a particular field e.g. 'checkboxupdate'. I already have a general update time/date field but this is updated whenever a record is updated.

 

I want the new 'checkboxupdate' field to only be updated with the date/time when the submission includes the change to write TRUE to the checkbox field.

 

As an aside I would need to ensure that the checkbox is read only if the value pulled back from the recordset is true........

 

Hope this makes sense.

 

Thanks

Demetri

[Pikachu2000]

It sounds as though you've already talked yourself through the logic of it, put together some code and see what happens. Post any problems you have.