Filtrere data i formular

not quite sure what you mean, can you explain please puppetmaster?

Do you want to change the recordsource in the search form?

That should be no problem, in the forms on open event

me.recordsource = "Postkilden"

I have a main form, with a button on, that opens a search form. the search form lets you set e.g. a date range (guess you can call it an advanced filter)
Normally the main form has a table as it's "source" (Postkilde in Danish), but in this case it doesn't, it's built from a query, that changes every time a selection on the form, Ordrelinier, is made.
I would like for my search forms "source" to be .....what...
me!Ordrelinier......something....

"Postkilden" is a property of the form.

You could also pass the recordsource FROM your main form to your search form in the OpenArgs paramater when you open the from, then set this in the On Open event.

something like this
DoCmd.OpenForm "YourForm", , , , , , Me.RecordSource

Then in the Search form

If Len(me.openargs) > 0 Then
Me.recordsource = Me.openargs
end if

I assume that you know which table the query is based on? Then you could use the method I describe to sentthe table name to the search form. But this may mean that the search form also needs to be changed because field names etc. dont have the same name.

Have you looked at search manager pro? Sounds like its something lik ethis you need!
http://www.databasecreations.com/prod_srchmgrpro.htm

Eller:

docmd.Openform "Din søgeformular"
Forms![Din søgeformular].recordsource = Me!recordsource

Må kigge lidt på Terry's forslag om Search Manager Pro også, men forsøgte med dit forslag, thomas.
Satte en VedKlik event på knappen på min hovedformular, Ordreseddel:
  Forms![Transporter].RecordSource = Me!RecordSource
  DoCmd.OpenForm "Transporter"
Men fik en fejl:
"Kan ikke finde feltet "Recordsource"...."

sorry...skrivefejl:

docmd.Openform "Din søgeformular"
Forms![Din søgeformular].recordsource = Me.recordsource

I though about that Thomas but that will give the whole query and not just a table and thats what puppetmaster says (or at least I think he does) that he doesnt want.

Rettede den til Me.RecordSource, så forsvandt fejlen, men linien
DoCmd.OpenForm "Transporter"
fremkalder nu en fejl:
"Formularen Transporter kan ikke findes".....den ER der.... :(

Terry, I want the search form to "have" the same data as the main form, so Thomas is correct.

Min fejl, det var IKKE DoCmd.OpenForm "Transporter" der fremkalder fejlen, der ER stadig Forms![Transporter].RecordSource = Me.RecordSource

Hvordan fortæller jeg at Transporter er underformular til Ordreseddel?

You need to open the main(search) form and then set the recordsource of the sub form

forms!YourMainSearchForm!TRansporter.form.recordsource

helt præcist burde det være sådan:
Forms!Ordreseddel!Transporter.form.Recordsource = Me.Recordsource

DoCmd.OpenForm "Transporter"
  Forms!Ordreseddel!Transporter.Form.RecordSource = Me.RecordSource
Resulterer i: OpenForm handlingen blev annulleret

  Forms!Ordreseddel!Transporter.Form.RecordSource = Me.RecordSource
  DoCmd.OpenForm "Transporter"
Resulterer i: Kan ikke finde feltet "Transporter", der refereres til i udtrykket.

det skal nok være således:
DoCmd.OpenForm "Ordreseddel"
Forms!Ordreseddel!Transporter.Form.RecordSource = Me.RecordSource

!
what is the name of the MAIN (search form)?

Docmd.OpenForm "YourMainSearchForm"

I think we are getting all mixed up in the form names!
We need the name of your main form and if it has a sub form which contains the record source then we need taht forms name too.
Then we need the name of the MAIN search form and also the sub form name if it has one too!

Main form: Ordreseddel
Search form: Transporter

(Hvornår er det nu man bruger ! og hvornår .?)

Hvis der hele tiden kun er én formular åben (altså en hovedformular med en underfomular), så skal du ikke have nogen Docmd.Openform.

Så skal du bare skifte recordsorcen på underformularen med denne:

Forms!Ordreseddel!Transporter.Form.RecordSource = Me.RecordSource

! bruges KUN og altid, når der kommer et objekt bagefter

. bruges når der kommer alt andet en et objekt bagefter (dvs en egenskab eller en metode)

terry, I might have explained it wrong! :( Sorry
I have a form (Ordreseddel) with some data. These data I need filtered. For this I want to open another form (Transporter), on which the user can set criterias

so there IS no sub form?

The system is NOT a master-detail, pardon my use of the word "sub form".

So in fact you want to search on Transporter and then update the OrdreSeddel?

Forms!Ordreseddel.Recordsource = Me.recordsource

Yes!

that was a bit "round the house" :o)

"round the houses"

Oh....Oh! I guess I got it ALL wrong! :(
I DON'T need to "base" my search form on a recordsource at all, I just need to "read" the variables from the search form and set the form Ordreseddel's recordsource to the filterstring!

Sounds like you did, thats another problem entirely!

hmm:

docmd.Openform "Ordreseddel",,,Me.Filter

Jeg takker mange gange for hjælpen, blev "lidt" forvirret, da en anden af mine databaser's søgeforme ALLESAMMEN baserer sig på en tabel.

I would like to give you points too, terry.... ;)

that would be nice :o)

so I assume that you are setting the filter property on the search form?