Søge i form og sub form samtidig

Du kan bruge denne til at søge efter en værdi i feltet kundenr i din formular:

Dim VARa As String
VARa = InputBox(Prompt:="Indtast kundenr.", Title:="Find kunde.", Default:="")
DoCmd.GoToControl "kundenr"
DoCmd.FindRecord VARa, acEntire, False, , True, acCurrent, True

Hvis du derefter vil søge i underformularen, er du nødt til at sætte focus på denne først.

could you give an example as to when this would be necessary?

Normally the information on the main form isnt the same as that on the sub form.

Det udelukkende p.g.a. brugervenlighed, da brugerne ikke har den store it erfaring

Tak for point.

?
So what your saying is you have the same information in the main form and the sub form, and that is to help users :o)

Terry-> Mon ikke han prøver at lave en funktion, til brugerne, som betyder, zt disse ikke behøver at vide, om den information de søger, står i hovedformularen eller underformularen :-)

Yes I know what he want bit in my world I wouldnt have for example a "kundenr on the main form and on the sub form". But thats not saying that there will be situation wher it could be an a good idea. But thats what joki wanted and thats what he go so everyones happy :o)

Sure :-)

Terry>> An example could be: Company info on the main form and Contact persons on the subform.
Very often users by mistake create "company records" with person names in stead of company names. In this case a single seach field would make it possible to seek through all company names and contacts in one go.