Checking for duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to check a table for duplcate information as I am entering information
into the form linked to the table. Unfortunately, I can not make the field I
am checking a key field with no duplcates, because there are times when the
field is empty. I need to be able to look for a duplicate number and pop up
a window stating that the particular numbe I entered is already in the table
and does the person want to continue adding the information.

Hope this make sense.

Thanks
 
THis is close to what I need. But, I am looking at a different table than
the one I am in. What I am doing is adding a record to another table from
the current one. I need to check the table I am adding the record to. Any
ideas?
--
Cyberwolf

Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
 
Back
Top