Date Default with Yes/No box help

[Losartan]

I have a date field that I want to default to the current day on the form opening. I have a yes/no box that defaults to no. When the user selects the yes/no box, I want the default date field to become blank.

Any ideas on how to do this?

Thanks,
Jason

 

[pbaldy]

Set the default to Date(), and in the after update event of the checkbox:

If Me.CheckboxName = True Then
  Me.DateField = Null
End If

You may want to add an Else to handle them unchecking the box.

 

[Losartan]

that worked perfectly!!! Thank you so much!!

I appreciate it!!
Jason