You had told me that the Waterfront Number field is a Number data type.
It isn't. It is a Text data type. Therefore, your macro Condition
shopuld read...
DCount("*","Employees","[Waterfront Number]='" & [Waterfront Number] &
"'")>0
Yes Steve it works now. I thank you so much. This is the first time that I
used this discussion forum and I must say it was well worth it. Thanks again.
Katherine Clark
Steve Schapel said:
Katherine,
I have received your database file.
You had told me that the Waterfront Number field is a Number data type.
It isn't. It is a Text data type. Therefore, your macro Condition
shopuld read...
DCount("*","Employees","[Waterfront Number]='" & [Waterfront Number] &
"'")>0
--
Steve Schapel, Microsoft Access MVP
I don't think its too big. Am I to type the email as you type it?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.