Preventing duplicates on form entry

[Damo10]

Hi,

I am having trouble getting the vba code to check for duplicates working.

I have a table called tblPEMAC with a field called PEMAC and on the form there is a textbox called txtPEMAC.

How can I get it to check for duplicates?

Regards,

 

[spikepl]

" Having trouble" is BS. Say what you want and show what you did, in code. And where.

 

[jdraw]

check for duplicates??? Duplicates of what exactly?
Do you have your tables designed? Do you have your relationships designed? And tested?
Do you understand Normalization? It's a good place to start.

Good luck.