Unanswered:  OpenForm not filtering to record from report
I have a report that I want to be able to edit a record when an Item is clicked.
Form named: "Consults Form"
report named: "Consults"
The Database has a field named SSN = set to text
On the form there is a textbox named txtSSN
So on the report it generates I set the SSN "box" when formatting to Hyperlink on so that it has the blue area/link underline. I then went to ON CLICK events..and have tried everything under the sun that matches any example i could find googling/etc. Here are just a few...
It opens the form, but its blank and does not goto the record. When i goto Design view on the form, the FILTER area shows [SSN] = CORRECT INFO/grabbing the record I need.
if I manually goto the bottom of the form and type in the search just the data, it pulls it up fine, but not from the FORM when I click. I have done MSGBOX SSN, SSN.text, ME!SSN, etc... and they all pull the same data and show it correctly, but its not passing it to the form to show the record.
I had to do a similar thing with one of my reports and after lots and lots of serching i used this macro. Not sure what it would be in vba code but this is the macro i have set up
If IsNull([ID)] Then
If Not IsNull([ID])
Filter Name BLANK
Where Condition = ="[ID]=" & [ID]
Data Mode BLANK
Window Mode Normal
Go to Next
I put that on each column so no matter where in the row they click it will bring them to the edit form