I have a form and one subform. One form is an employee lookup. Second form is for data entry. What I want to do is to restrict employee to input duplicate records based on employee and date.

For example, if employee login and inputs date as 4/10/00 and then attempts to try again with same date.

Thanks. Help would be nice.

So one employee can only be connected to one date? In the data entry table, go to design. Create an index (view menu) that includes both the employee and the date so that only one entry can be made with that combination. i.e. "Jane Doe 2/6/00" can only appear once. If the user tries to add this date to this name again, s/he will receive an error message.

i understand your idea but when i did it, it restricted other users to use the same dates too.

i think i am doing something wrong...can you help me out?