By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

syntax...

P: 59
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 ?
Sep 7 '07 #1
Share this Question
Share on Google+
3 Replies


P: 65
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
Sep 7 '07 #2

FishVal
Expert 2.5K+
P: 2,653
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
Sep 7 '07 #3

P: 59
thank you very much :)

btw.. only this works:

Forms.Item(frm).Filter
Sep 7 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.