Auto opslåning af resultater!!!!!

I would suggest you try making your tables first. Once you have your tables in place the rest will be much easier to make.

Men når jeg så har lavet dem hvaså???

You can use the form wizard to help you make your forms.

Det er ikke noget problem at lave formen, men hvordan får jeg den til at liste de enmer der passer med det jeg har indtastet????

'Place a button on the form and when you press the button call this function


Function NewFilter()
Dim sFilter As String
   
    sFilter = "1 "

'Then for each field you have similar lines to these three. You need to alter the field names!
    If Not fldIsEmpty(Me.fld1) Then
        sFilter = sFilter & " AND DataBaseField1 = " & Me.fld1
    End If
     
   
    Me.Filter = sFilter
   
    If sFilter = "1 " Then 'No filter
        Me.FilterOn = False
    Else
        Me.FilterOn = True
    End If

End function

'Place this in a module

Function fldIsEmpty(fld As Variant)
'Returns True if the field is empty. Otherwise False.

    fldIsEmpty = IIf(IsNull(Len(fld)), True, IIf(fld = "", True, False))
   
   
End Function

Thanx but I really don't know what to do here???

Can you please try telling me it alittle more specific???

if you have already made your tables and forms then you can send it to me and I will do it for you dktebrsa@europe.lego.com

Otherwise it isnt going to be easy to explain!