Time Fly's

[satty]

guys,

I am having a problem with dates. i have a membership form on which i have added:

> membership Start Date and;
> Membership Expiry Date.

I am trying to get my database to prompt the user 1 day before the expiry date and then on the expiry date again.

is this possible?

i have just about tried all i can ?

Thanx again

 

[Mile-O-Phile]

You'll want something like this in your form's Current event.

If ((DateAdd("d", -1, Me.txtExpiry) = Date) Or (Me.txtExpiry = Date)) Then
    MsgBox "This is going to expire.", vbInformation, "Example"
End If