Hi,
I have multiple item form based on query with active users
http://i.pics.rs/U5fq0
Query field days left calculates days between today and date when membership expires.
http://i.pics.rs/gDVdR
In active users form i have Send e-mail button which sends email to user.
What i want is that on button click(not send e-mail button from above) or on form load access sends email to every person when days left field value is 0.Code:Private Sub command41_click() DoCmd.SendObject , , , Me![E-mail], , , "Gym", "Text" End Sub
Best regards