Auto Update

[Brutal]

Hello
There is a field in my table called "complete" and is a controled by a yes no radio buttons i.e when a user click a radio button the field gets a 1 or 2 put into it. What I would like to do is when that field is changed is to have a date field to automatically get todays date entered in to it.
Any ideas please.

Thanks

Paul

 

[shay]

Hi

Put

txtToday = Date()

in your option group's afterupdate event.

hth

shay

 

[Brutal]

Could you please tell me what the txtToday means or should i be replacing this with the table filed name that I want Date() to load in to

Thanks

Paul

 

[The_Doc_Man]

Shay's remarks were in the right direction but he confused you, so I'll step in and take my view on it


Let us assume that the radio button group is called [Complete] on the form, and that the same form has [DateCompleted] on it as the date in question. (It does not matter if the field is actually visible, it just has to be on the form.)

In the event routine

Private Sub Complete_AfterUpdate

[DateCompleted] = Date()

End Sub

 

[Brutal]

Thankyou

Thankyou both very much
It is work a treat

Paul