finding duplicate values on a form

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?
 
A

Adrian Jansen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

finding duplicates in a form 1
Word 2016 opening sooo slow 0
Using DLookUp as the default value of a Forms ComboBox 5
Combo Box Default Value based on a query 7
Duplicate record in Form and Subform 0
error in highlighting duplicate values in excel 1
How do I clear a form? 0
Pls Help - default value in a subform 1

Top