Forum Discussion

Tony2021

Iron Contributor

Dec 31, 2021

Solved

OpenArgs, Filter

Hello Experts, I have a form that has On Load that opens if Nz OpenArgs. The form's data tab shows its filtered to [LetterOfCreditID] = xx (whatever record the [LetterOfCreditID] was filtered to...

access

Karl_Donaubauer
Dec 31, 2021
Hi,

I did a quick test with that setting and it works here, i.e. the ApplyFilter macro filter gets replaced by the new filter. Maybe in your case there's sth else involved. What happens when you try it? Nothing at all?

Personally I would not mix VBA mit a macro but do all filtering by code with

Me.Filter = ...

Maybe this also enables you to set back the filter as described, by just calling OnLoad again. No Requery/Refresh etc. is necessary when I do this here. I just have to change the Filter property.

Servus
Karl
************
Access News
Access DevCon

Karl_Donaubauer

MVP

Dec 31, 2021

Hi,

The order of what you want to accomplish is not very clear to me. You want to filter for the OpenArgs first, then with the ApplyFilter macro and as a third step back to the OpenArgs filter? Or differently?

With which code OnLoad do you set the filter based on the OpenArgs?

In which event do you call the macro?

Where and when do you want to "reactivate" the first filter? With a button in the form?

The right method depends on such details of your current implementation and on your concrete requirements.

Servus
Karl
************
Access News
Access DevCon