Unanswered: how to reference subform's recordset field value
How can I reference a value in a sub-form recordset, if that value is not displayed on the subform itself?
My subform recordsource is
SELECT contact_no, case_no, ssn, name, dob FROM contacts
The parent and subform are linked through case_no
On the subform (datasheet view), only ssn, name, and dob are shown.
Essentially, I'm trying to allow the users to double-click on a line in the subform and have a separate normal-view form open showing that contact. For this I use contact_no, the field not shown on the subform but which exists in the recordset. It works the first time you double-click, and the window opens fine, but when you try it again a second time it doesn't work.
Here's the line that doesn't work (it's in the subform code module):
contact_id_long = me.recordsetclone.contact_id
Basically, my contact_id is my handle, but I don't want to show it on the subform, because it's not meaningful to the users. I can't use SS# for my handle.