Searching For Records In A Table

[Playa]

I have A Drawing Number field on a Form and after a user enters a new Drawing
Number I want to check and see if it already exists in the table. I was
going to use the DLookup to check but that only returns the first Drawing
Number in the table, it doesn't see any records after that. What code would
I use to check ALL the Drawing Number records in the table?

Can Anyone help me????????

 

[Sandra Daigle]

I just answered your other question - you really should wait at least 24
hours before posting the same question again - check out the guidelines for
newsgroup usage so you will understand the best way to get the most from
them:

Please see http://www.mvps.org/access/netiquette.htm for more information.

It sounds like you have not used any criteria on your Dlookup statement.
Review the example in my other post and let me know if that helps you.