SendObject Automatically

[DaveHam]

I'm new to Visual Basic and my project is to get Access to recognize the date in a field and send an e-mail only if the current date [Date()] matches the date entered in the field. There is a different date for each record (all in the future) so I want this to be a continual process well into the future.&nbsp;&nbsp;I've gotten the code for the sendobject, but how do I write the If/Then statement that tells Access when to trigger it?&nbsp;&nbsp;&nbsp;<br>Thanks for the help!<br><br>David

 

[Amiel]

Assuming [text1], and [text2] hold the values in question...<br><br>Private Sub Text1_OnExit() 'heres where we launch the DoCmd<br><br>If Format([text1],&quot;mm/dd/yyyy&quot = Format([text2],&quot;mm/dd/yyyy&quot Then<br>&nbsp;&nbsp;&nbsp;DoCmd.SendObject,,,,,,<br>&nbsp;End If<br>End Sub<br>Couple of things here. Both values must be valid date data types. Use the input mask wizzard, and use the 'short date', then add two additional zeros (y2k!). This keeps the users on track when entering dates.<br><br><br> <p>Amiel<br><a href=mailto:amielzz@netscape.net>amielzz@netscape.net</a><br><a href= > </a><br>