Filtername question

[David44Coder]

I beg indulgence as I try and ask about something I don’t quite follow.
It concerns the FilterName passed via Docmd.OpenForm

The Filtername here is a just-constructed Query at run time. The forms recordsource is a different (permanent) query.
The Form opens showing all the fields in its record source, NOT all the fields in filtername query.

And only those records that match the Where Clause in the filtername query.
So I changed the filter query to just Select * from Table Where.... x= y and find this works exactly the same as before the change
So the Form uses the field specified in the Where clause Filter ? Is this correct?

I may be confusing Filtername with Record Source. What should Filtername be? A query where only a part of it is used ?
I did try the Where syntax that might be used in e.g. FindFirst or DLookup but that didn't work.
If I open the Form directly it shows a completely different set of data (which matches it Property Sheet)

 

[June7]

I have never used FilterName argument, only WHERE CONDITION.

WHERE CONDITION follow rules of SQL WHERE clause.

Review https://docs.microsoft.com/en-us/office/vba/api/Access.DoCmd.OpenForm

Why would you use FindFirst or DLookup with WHERE syntax? Provide your code for analysis.

 

[theDBguy]

Hi. Very good question. I am not 100% sure, but I think all FilterName does is use the WHERE clause in that query against your Form's RecordSource.

 

[David44Coder]

Thanks for clearing that up dbGuy.
June I'd never used either Filtername or Where before and it looks like Where is all that's required.
I changed to that and got it working.