Running a query upon the click of a button

[Geodon7]

I need to run a query upon the click of a button that will check to see if the Project Name entered in the form already exists. If it does, then I need a message to come up saying it already exists. If it doesn't, then no message is needed. I'm not sure how to do this (or set it up), but I would think that I would need to run a query against the Project Names and if it's returned empty then nothing is done, but if a record is returned, a message should come up. Any suggestions? Thanks all.

G

 

[LarryDeLaruelle]

Geodon:

I would suggest using the DLookup function. Access help provides a good explanation (at least in A97).

Your difficulty will be in making a match based on how the user enters the information. A single character difference between the way the new name is spelt and an existing name is in the db will result in no matches. Larry De Laruelle
ldelaruelle@familychildrenscenter.org