Hælp til søgeform eller anden løsning

The sub form is actually gets opened before the main form, so what you could do is in th emain forms On Current even or load event requery the sub form

Me.SubformObject.form.requery

where SubformObject i sthe name of the subform object. This is NOT th esame as the sub form although the names are quiet often the same!

Tak for dit bud terry. sådan som jeg forstår dit svar så vil du lave en requery efter at hovedformen er åbnet. Men da subformen stadig er baseret på en forspørgelse (med kriterier) så vil jeg vel stadig blive spurgt om parameter, når hovedformen åbnes

So wait until the main form is oepn before setting th esub forms record source.


Me.SubformObject.form.recordsource = "SELECT ........"

Hmm forløbig tak, jeg er da kommet det nærmere, men får fejlen.
" det intastede udtryk refererer til et objekt der er lukket eller slettet."

Alter the sub forms recordsource to an SQL which contains a selects WITHOUT parameters from the main form. Use this as the default. This shoul densure that the link fields are avialable. Then alter the recordsource when th emain form is open.

Det ser ud til at virke på denne måde, tak for hjælpen.
Det virker lidt som dobbeltarbejde og lidt klodset, men er det sådan man normalt gør ?

"men er det sådan man normalt gør ?"

Well its hard to say! Normally records in the sub form are related to one record in the main form through a primary key/foreign key which can be more than one field. These are the fields which are used in the link child/parent properties of the sub form object. I don tknow anything about your program so I dont know why it is necessary for you to include criteria from the main form in th esub forms record source. But if I did know more about your application then I am sure other suggestion scould be made concerning a solution! As it is now thoughm this is about as close as you will get.

okay det er ok, var bare nysgerrig. jeg holder mig til det kendte udtryk " Never touch a running system" Vo lader det være, jeg har jo fået løst opgaven.

Glemte at acceptere svar, det er nu lukket

:o)