finding duplicate values on a form

  • Thread starter Thread starter D. Schwarz
  • Start date Start date
D

D. Schwarz

I have a form that contains a combo box called Status_id
which contains the values open, closed and future. I want
to prevent two periods being open at the same time. I
have tried creating a query to find all opens and then
using rs.recordcount and I have used vlookup() to no
avail. It always returns the wrong value. Can someone
help?
 
Look at the query generated by the "Find Duplicates" query wizard for some
ideas.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top