i need your help
i want to prevent duplicate recored in form which tabe have fields name 1- empname type text 2-bookno type number and bookdate type date who can i solve my problem with Dcount I try this code below but i have runtime error 3075.
if DCOUNT ("*",[TMAIN],[bookno]=' "& me.bookno &"and [bookdate]= #" & me.bookdate& "#")
pls if u don't mind help me to solve it
> appreciate your help
>