yes / no box and updates

[WHYDO4399]

Is it possible to set up a check box so once it is changed I can have a different field update with the current date and another field update with teh current time?

In addition, once this update takes place, is it possible to then make the fields that already have data populated once the check box is checked read only? so the user can no longer make updates to this?

Thanks in advance.

 

[TheAceMan1]

How are ya WHYDO4399 . . .

Curious this! Although the origional fields can be locked (no editing), [blue]whats the point of the transfer to the alternate fields when the origionals can still be read?[/blue]

Special Note: for this to work, the [blue]checkbox[/blue] would have to be added to the underlying table!

[blue]Your Thoughts? . . .[/blue]

BTW: Welcome to [blue]Tek-Tips![/blue] Do have a look at one of the links at the bottom of my post. The links will help you [blue]ask better questions[/blue], get [blue]quick responses[/blue], [blue]better answers[/blue], and insite into [blue]etiquette[/blue] here in the forums. Again . . . Welcome to [blue]Tek-Tips![/blue] [blue]Its Worthy Reading![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]