I have a form that's in datasheet view
It has a subform also in datasheet view
The subform and parent form both have a column txtMyId
What I want to do is if Me.txtMyId <> Me.Parent.txtMyId then
Hide entire data row if possible
I tried testing with the following code and an extra unbound column to update
But it comes back with everything "Matches" which I KNOW isn't correct
Do I need some kind of "For Each?"
I can do that in .Net easily
If Me.txtMyId = Me.Parent.txtMyId Then
Me.txt2 = "Matches"
Me.txt2 = "No Match"