Sæt WHERE xx = i inde fra hændelsen vedaktuel

you can use the filter property for this. The filter property is the WHERE part of an SQL statemnt.

So if your record source is "SELECT * FROM MyTable"
then me.filter ="someField = 10"

is the same as "SELECT * FROM MyTable WHERE someField = 10"

And you need to set
Me.FilterOn

if theres a WHERE
Me.FilterOn = True
and if there is no where then
Me.FilterOn = False

Den løsning kender jeg men ulempen er alle record "populært sagt listes ud" for derefter at selektere.
Det er jo tidsrøvende.
Det var bedre om Select ... blev udført fra start kun med de record der fordres

Hvis der ikke findes en bedre løsning vil jeg måske lave en SELECT uden WHERE...
lagt i vedaktuelt, og så selectivt sætte
If ...
Where ...
elseif...
Where...
.
.
Hvad er din erfaring ?

"Det var bedre om Select ... blev udført fra start kun med de record der fordres"
How do you know what the "WHERE ...." is to be BEFORE the form is open???

And if you know what the WHERE is then you can change the Me.Filter property...

Where do/will you have this code?
"If ...
Where ...
elseif...
Where...

If you know the WHERE beforew you open the form then you can change the record source to include the WHERE. That can be done in a couple of wways, either change the SQL for a query you use as the record source, or change the SQL directly in the record source, which means building the SQL dynamically (IE if the WHERE changes, then you change the SQL....)

But then you might as well change the Me.Filter property.

I dont really see the problem, maybe we dont have the full picture?

Det kan være Filter er den rigtige løsning.
Jeg havde bare en fornemmelse af den er langsom derfor søgte jeg en bedre løsning.

Har du erfaring for hvad der selekterer hurtigst WHERE eller Filter ?

"Har du erfaring for hvad der selekterer hurtigst WHERE eller Filter ? "

I have never notived any difference. I can imagine that behind the scenes its the same code which executes the SQL.

notived = noticed

Så vil jeg bruge Filter
Tak for hjælpen

selv tak