Unique number "event is in" the db table vs "is not in" event

[RuralGuy]

It sounds like the FindFirst is never locating the duplicate. Can you put a MsgBox in the procedure that shows the value of Me.RecordsetClone.NoMatch? Any chance of you posting your zipped up db so I can look at it?

[hawzmolly]

I have removed the names from the tblContact to maintain HIPPA. I have included three phony names under three ficticious MRN's - 000001, 000002, and 000003. The rest of the MRN's are actual patient MRN's.

The form in question is "frmPatientEntry" for initial data entry and the readmit form is "frmTimeData".

Have a ball and thanx for looking.

[RuralGuy]

Hi Molly,
The main problem was that the form had the DataEntry property set to YES so the RecordSet AND the RecordSetClone had no records. Only New records are returned when this property is YES. I simply used a new RecordSet for the .FindFirst You will see I made some changes to the two forms and created a couple of queries. It is always a good idea to use queries of tables rather than tables directly. I would also set the sort criteria in the query rather than the form.

[hawzmolly]

Thank you very much. I think I have found the error of my ways with your help. I am sure I''ll be back with another question or two on any number of issues this rookie will definitely run into.

[RuralGuy]

Glad I could help. Are we ready for the link in my signature yet?

[hawzmolly]

Sorry, I don't have a clue what your question means.

[RuralGuy]

It looks like you already marked this thread as Solved. The link in my signature takes you to the directions for doing do.