filter unbound forms

ckiley

Registered User.
Local time
Today, 17:25
Joined
Sep 15, 2005
Messages
10
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?
 
It should be:
Code:
With Me.frmNodeInfo.Form
   .Filter [color=red]=[/color] sFilter
   [color=red].FilterOn = True[/color]
End With
 

Users who are viewing this thread

Back
Top Bottom