Display message if reminder date is todays date?

[KevinSlater]

Hello, In need of some help on something fairly simple (well when you know how) I have a form with a subform, in the subform I have text boxes showing employee names (in a continues form) and reminder date text field boxs showing a list of reminder dates.

I would like a message to be displayed when the user enters the main form if a reminder date is the same as whatever todays current date is and displays the Employee name its related to, I think I need something along similar lines to the below code, on the on load event of the main form but this doesn’t work

Private Sub Form_Load()
if("d",Now(),[REMINDER_DATE]) then MsgBox "Reminder date for this employee is today: " + [EMPLOYEE_NAME]
End sub

(The reminder date name in the query/table is REMINDER_DATE and is called textbox_reminder_date in the subform)

Any help appreciated, thanks

Kevin