I'm sure the answer to this is quite simple, but I'm not a programmer by trade and simple things catch me all the time:
I have a treeview on a form. When a user clicks a node on the treeview, one of three forms appears in an unbound subform next to the treeview depending on which level node is clicked. I'm just switching the sourceobject of the unbound form to do this. That part seems to be working fine.
Now, I need to filter the form that appears to only show the record for the node that was clicked. I thought this would be the simple part, but I keep getting an "invalid property" error when I try to reference the subform.
This was the code I tried to apply my filter, and I'm stuck now.
Me.frmNodeInfo.Form.Filter sFilter
What am I doing wrong?
I have a treeview on a form. When a user clicks a node on the treeview, one of three forms appears in an unbound subform next to the treeview depending on which level node is clicked. I'm just switching the sourceobject of the unbound form to do this. That part seems to be working fine.
Now, I need to filter the form that appears to only show the record for the node that was clicked. I thought this would be the simple part, but I keep getting an "invalid property" error when I try to reference the subform.
This was the code I tried to apply my filter, and I'm stuck now.
Me.frmNodeInfo.Form.Filter sFilter
What am I doing wrong?