Applying filters

[Guest]

I have a treeview that I want to be a filter for a subform.
I mean, that the subforme should be filtered by the node selected in the
treeview.
I do not how can i do that because DoCmd.ApplyFilter should be executed
throu a button, i guess.

Please, help!!

Thanks a lot, Lina

 

[Alex Dybenko]

Hi Lina,
you can look at this sample:
http://maug.pointltd.com/access/Queries/DownloadsList.asp?dlid=11

it does not use treeview, listbox, but you can learn how to apply filter
for treeview - idea is the same, you use Node_Click event to get a selected
node and then run code to filter subform

 

[Guest]

Hi Alex

I did download the splitter, but I could not find where the filter for the
subform is.

Can you help me wit this?

Thanks a lot, Lina

 

[Alex Dybenko]

Hi Lina,
yes, you right, I made it long ago, and there I use a different approach
anyway - what you can do:
in a Node_Click event you get build a filter string, for example
sftFilter="CategoryID=" & intCategoryID
intCategoryID - you get from clicked node
and then you apply this filter to subform using it filter property:

me.frmProductsDetail.form.Filter=strFilter
me.frmProductsDetail.form.FilterOn=True

HTH

 

[Guest]

Hi Alex

Almost done!
I have this in a node_click event:
strFilter = "IdCmpny=" & Mid(nSelectedNode.Key, 2)
Me.frm_SalesBase.Form.Filter = strFilter
Me.frm_SalesBase.Form.FilterOn = True

But the form is asking me for the value of IdCmpny.

So, I have been doing soe thing wrong, don't I?

Thanks a lot, Lina

 

[Guest]

Alexxx!!!!

It did worked!!!!
I had the wrong Id...

Thanks a lot!!!

Lina