Fritekst søg i hele tabel fra frm-søgefelt

I think you will need to build the SQL dynamically. I assume the form also needs to show all records so the Records Source will be something like

SELECT * FROM SAP_Week

Now when you enter your search string you need to Build the WHERE part which goes into the Filter parameter (WITHOUT WHERE)

So Me.filter = "Field1 LIKE *YourSearchString* OR Field2 LIKE *YourSearchString* OR Field3 LIKE ..."
Then turn filter on
Me.filterOn = True

I have an example showing how you can build the Filter, I'll need your email..

Det kan godt være, det er for enkelt; men du kunne jo også bare bruge søgefeltet, som Access er født med (i bunden af formularen). Det søger i alle felter.
"Find næste" er Enter-tasten.

Dim strsog As String
Dim strtekst As String
strtekst = Me.Søg5.Value
strsog = ("SELECT*FROM SAP_Week_new WHERE(Material Like " * "" & strtekst & "" * ")")
Me.RecordSource = strsog
End Sub

Hvad er forkert her ??? Jeg får en Run-time error '13' / Type mismatch

"SELECT * FROM SAP_Week_new WHERE Material Like  * '" & strtekst & "'"

You could try fdata's idea

You can also use the records source instead of filter but to remove the search criteria (filter) requires you change recordsource again. If you us efilter you only need to change FilterOn to False

Hope you found a full solution to your question, not just one field

Hej
Jeg har ikke fundet den helt korrekte løsning, så jeg vil meget gerne hvis du kan sende mig et eksempel på den løsning som du har.

nymark@has.dk.

På forhånd TAK

example sent with explanation :-)

that email doesn't seem to work :-(
I'll try without attachement...