limiting number of times users can add the same account per day

[iamratman]

During a promotion we are running the customers are only allowed 3 entries into the system per day but the users are occasionally putting some customers in more than that. I could use some kind of function that limits the number of times the account number can be put in on a given date. (Or daily)

I have the following text boxes: ID, Customer first name, customer last name, account number, date, time.

Any ideas please?

 

[naminder]

is the Id an autonumber field or unique to the customer? you could try by finding what is unique. then run a query before they enter that counts how many entries they have

If ID > 3 And Date Between "Lirst" Date and "Last" Date Then
Msgbox