Valitation?

[Jamie]

Hi i have a form which has the following fields.

Completed and completion date

Completed option is a yes/no tick box and completed is in
date format.

If a user clicks the yes box to sginify the call has been
completed i want it to propgate the current date in the
date completion date field.

How do i go about doing this?

Thankx for taking the time group

 

[Louis Bourbeau]

You may use the click event on your yes/no tick box. So when your yes box is
clicked your completion date will be equal to the current date:

Private Sub Yes_No_Box_Clicked()

If Yes_Box then

Completion_Date = Date()

End If

End Sub

Or on your form Before_Update Event you could check the status of your
yes_box and set your completion_date properly :

Private Sub Form_BeforeUpdate()

If Yes_Box.checked == true then

Completion_Date = Date()

End If

End Sub