What can I put in my query to show that a field bein duplicated

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

Guest

What can I use in my query to warn a data entry person that they are keying
in a
duplicate record.


Thanks,

Big Mike
 
There is nothing you can put in the query that will do this. If you are
using forms to control input (which you should be) then you can use VBA code
to check.

How many fields are involved in determining that the record is a duplicate
record? At what point do you want to determine the person is entering a
duplicate record? What do you want to do if the record is a duplicate?
 
Back
Top