Auto Fill Date Field on Form 1

[mizenerman]

Hi.

Being fairly new to Access I'm sure there is a way for all you smarty pants' to assist me. I think it's fairly easy.

Fields in form:
Curative Treatment
Date of Primary Treatment
Surgery Date

When Curative Treatment = Surgery I want the Date of Primary Treatment (entered manually) to push to the Surgery Date field.

Thanks in advance for your help.

 

[PHV]

Something like this ?
In the AfterUpdate event procedure of the Date of Primary Treatment control:
If Me![Curative Treatment] = "Surgery" Then
Me![Surgery Date] = Me![Date of Primary Treatment]
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mizenerman]

Thanks PH! That's exactly what I needed.