syntax...

[zivon]

Hello everyone !

when I write Forms![Orders].Filter it works just fine...
but insted of using it for each form with another function I'd like to use a var named 'frm'

Forms![" & frm & "].Filter

what is the right syntax of using it ?

[Twanne]

Hey,

The var you use, of witch type is it? Because if you use a var of the type form you can just use <varname>.Filter to add your filter. Just build a function like Function age(f As Form) As Form and you can give your form to your function and it should return a form with a filter.

Greetz

Twanne

I don't like things that aren't things

[FishVal]

Hello everyone !

when I write Forms![Orders].Filter it works just fine...
but insted of using it for each form with another function I'd like to use a var named 'frm'

Forms![" & frm & "].Filter

what is the right syntax of using it ?

Forms.Item(frm).Filter
or simply
Forms(frm).Filter

frm is string type variable

[zivon]

thank you very much :)

btw.. only this works:

Forms.Item(frm).Filter