How to use filtered subform for source object of another form

masoud_sedighy

Registered User.
Local time
Today, 02:36
Joined
Dec 10, 2011
Messages
132
In my main form I have a tree vew at left part and a subform at right part when I click on each node it shows me data at right part with using below code:​
Me.fsubItem.SourceObject = "form." & "fsubIso"​
Record source of "fsubIso" is "qryIso"​
Now I like to add a button/node to main form when I click on it , it opens new form (search form) for entering some criteria and then press "ok" button and it shows filtered "fsubIso" in right part of main form.​
If I wanted to open just filtered form "fsubiso" I did not have problem, before I was using something like below code:​
DoCmd.OpenForm fsubiso", WhereCondition:=varWhere​
My problem is how I have to do​
Me.fsubItem.SourceObject = filtered "fsubiso"
 

Users who are viewing this thread

Back
Top Bottom