Create a record on current mont

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hello, I have a query named qryYearlyReview and it gives me all the employees
whos Date Of Hire are in the current month. The fields are:

1) FirstName
2) LastName
3) DateOfHire
4) CurrentMonth: Month([DateOfHire]) Criteria: Month(Now())

I want to run something in my Main Form that would run this query and save
those names to a table named tblYearlyReview with these fields:

1) FirstName
2) LastName
3) DateOfHire
4) Completed "Check Box"

I want it so if there is already the same record then it wont create a new
one. This is so I can have a reminder that an employees yearly review is due
in the current month and when I check the completed box in the
tblYearlyReview then it wouldnt show again untill it creates a new record
next year. How would I do this?
--
Thanks,
Chad
.