Solved Save Filter as Favorite for each user by himself

[theDBguy]

Hi, I tried to do it but it does not work
plz help!
View attachment 95825

Try the ApplyFilter action. You might also try using DLookup().

Sent from phone...

 

[Sarah.M]

Try the ApplyFilter action. You might also try using DLookup().

ApplyFilter it dose not work where I can put Dlookup()?

 

[theDBguy]

ApplyFilter it dose not work where I can put Dlookup()?

I was thinking you can use DLookup() to get the filter from the table. Then, you can use ApplyFilter to apply it to the form.

 

[Gasman]

I do not use macroes, hardly ever, but you need to read the help?
It states you must name the field and the value to be filtered.?
https://support.microsoft.com/en-us...o-action-10ffd4b3-a5c5-4f49-aa44-d2d4550095d1

 

[Sarah.M]

I do not use macroes, hardly ever, but you need to read the help?
It states you must name the field and the value to be filtered.?
https://support.microsoft.com/en-us...o-action-10ffd4b3-a5c5-4f49-aa44-d2d4550095d1

Hi,
it dose has Name Filter2 and the control has a name also, but it does not work with me

 

[Gasman]

That is not what your picture shows?

 

[Sarah.M]

That is not what you picture shows?

If I click on the Filter name and Run Filter nothing happened

 

[Gasman]

With your syntax I would expect that?

I cannot get it to work on 2007 and I was using
[Field]= Forms!Formname!ControlName syntax

 

[Sarah.M]

With your syntax I would expect that?

I cannot get it to work on 2007 and I was using
[Field]= Forms!Formname!ControlName syntax

Thanks for your reply,
I tried It doesn't work

 

[Gasman]

See if you can make head or tail of this video

 

[Sarah.M]

See if you can make head or tail of this video

Thanks,
I am trying to follow the video, but here I need to put numbers one by one

 

[Gasman]

No, all I was trying to indicate was that you have to specify the fieldname. All he was doing was copying the example from the MS help I linked to?

 

[Sarah.M]

No, all I was trying to indicate was that you have to specify the fieldname. All he was doing was copying the example from the MS help I linked to?

It doesn't work with me
Kindly plz help @theDBguy @arnelgp

 

[Gasman]

It doesn't work with me
Kindly plz help @theDBguy @arnelgp

I'll bow out

 

[Sarah.M]

I'll bow out

No plz stay with me we are learning together
Plz don't misunderstand me

 

[theDBguy]

It doesn't work with me
Kindly plz help @theDBguy @arnelgp

Check out this updated version.

 

[Sarah.M]

Check out this updated version.

It works!!!!
Thanks indeed!!!

 

[theDBguy]

It works!!!!
Thanks indeed!!!

Glad we could assist. Cheers!