where is the TimeText textbox located?
do you have the query Query1_due_date_Subform?
Yes I have the query Query1_due_date_Subform. The TimeText textbox is located in the Form Header.
Very difficult to help when you post pictures of code - especially when we can't see what happens when the error is raised. I think you will have to post a copy of the db to get focused help, unless arnelgp is willing to continue fishing. I'm out of bait.
You definitely do not want to create the same form just because of different criteria. To answer your other question about automating this, yes it is possible, but if you are at a very novice level, quite difficult although not impossible. It depends on how much time and learning you are able to put into it. One method would be to use Windows Task Scheduler to open the db and execute code to send email, which by the way, is very doable with Office applications in Windows.
Thanks Micron. I can post a copy of the DB. Where can I save a copy that you can have access?