Søgning i underformulare

Problem with this approach is that you want to search on the SUB form and show data on the main form and sub form.

What you could do is Use the dlookup function to find the "kunder" which has this fakura and then set the forms filter propery to this "kunder" this will show all orders for this kunde.

If you just want to show a specific order detail then I suggest you make a query joining the kunde+order tables and then make a form using this query.

Lav et tekstfelt på hovedformularen som hedder "Fakturanr".
På feltets AfterUpdate-hændelse lægges denne kode:

If Me!FakturaNr = "" then
  Me!Subform.Form.FilterOn = False
else
  Me!Subform.Form.Filter = "Select * From [" & Me.Recordsource & "] Where KundeID In (Select KundeID From tblOrdre Where Fakturanummer = " & Me!Fakturanr & ")"
  Me!Subform.Form.FilterOn = True
endif

Udskrift selv alle felt- og tabelnavne med dine egne.

/Thomas
PS: Koden er ikke afprøvet men blot indtastet efter gehør.

Denne her har godt noget tid på bagen. thomasjepsen smid mig et svar!

thnx :o)