If field is changed other 4 fields are set to Null

C

consjoe

Just a little over my head with this project...
I have a date field that has 4 quieres off it. One notification 25 days
before date, one date of, one 31 days after, and one 45 days after. After
the first notification is sent out the "First Notificatoin" field is updated
to yes, second notification sent, the "Second Notification" field is set to
yes. And same with the third and forth. This is so my query know this
notification has already been sent because the field says "Yes"
Well if the date field is changed on my form (for the next billing) I want
all "Notification" fields to be set back to null so it is picked up next time.
Thanks!
This is what I can come up with but of course not working:
If (Me.Date).Dirty then (Me.First Notification = "") and (Me.Second
Notification = "") and (Me.Third Notification = "") and (Me.Forth
Notification = "")
Endif
 
O

Ofer

On the after update event of the [Date] field you can write the code

Me.[First Notification] = ""
Me.[Second Notification] = ""
Me.[Third Notification] = ""
Me.[Forth Notification] = ""
 
Top