Valitation?

  • Thread starter Thread starter Jamie
  • Start date Start date
J

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
 
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
 
Back
Top