compare strings 1

[hoofit]

Good afternoon,
I would like to compare the string contents of an unbound textbox to the string contents of a field in a table so I can produce my own “duplicate entry” error. The field name is ‘PMName’ in a table named ‘PM’ and it is the primary key. I believe I need a DLookup function to search the field but I’m not sure of where to start. Something that ends up like (pseudocode) if textbox 1 = fieldEntry then msgbox blah blah blah.Can someone give me a push?

Thank you

 

[Remou]

Try this:
DLookup Function Examples
faq705-4978

 

[hoofit]

Thank you Remou, hits the spot.

-hoofit