search for existing name

[Mazza]

Hi Guys,
I would like to be able to type a name in a field which is not the unique
identifier and then have it flag me if that name already exists in that
field.
I need this badly and cannot come up with a solution. Can any help
Please????

Mazza

 

[fredg]

Hi Guys,
I would like to be able to type a name in a field which is not the unique
identifier and then have it flag me if that name already exists in that
field.
I need this badly and cannot come up with a solution. Can any help
Please????

Mazza

Answered elsewhere.
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.

 

[Mazza]

Thanks I was unaware of the multipost rules, I shall abide by them from now
on.
Mazza