Check table for existing record

[cybhunter]

I have a form that has a "ProjectName" Field on it. I want to look to my "ProjectEstimates" table (which has a "ProjectName Column") to see if that Projectname already exists so I know if I need to do an Update or Insert to the table. Can I get some help with this please?
Thanks in advance!

 

[pbaldy]

Simplest is probably using a DCount. Good reference on structure here:

http://www.mvps.org/access/general/gen0018.htm