Solved Forms On Load event VS Query Criteria

[Sarah.M]

Hi, Plz note, My VBA by default is disabled for security reason
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
-‐---------------------------------------------------
Hi,
Can I use the form macro Applyfilter on load event always instead of the queries criteria?
Because for example if I use Macro on load events gives me more customization for example
If user 1 login give him filter1
If user 2 login give him filter3 and so on
So what do you think is the best method?

Thanks!

 

[theDBguy]

I think the best method is the one that works for your situation and you're most comfortable using. Best could be different for every situation and person.

 

[Sarah.M]

I think the best method is the one that works for your situation and you're most comfortable using. Best could be different for every situation and person.

Hi thanks for replying
Can we use if condition in query criteria?
If user 1 login give him filter1
If user 2 login give him filter3 and so on?

 

[theDBguy]

Hi thanks for replying
Can we use if condition in query criteria?
If user 1 login give him filter1
If user 2 login give him filter3 and so on?

Yes, you can use conditions in query criteria. But, if you have a lot of conditions, it could get crazy.

 

[Sarah.M]

Yes, you can use conditions in query criteria. But, if you have a lot of conditions, it could get crazy.

Thanks!!!

 

[theDBguy]

Thanks!!!

That's what we're here for. Good luck!