Im stuck on another thing now. Do you know whats wrong with this sql in VBA.
Sorry for the late reply, im back at work now.
edit: Ill change row to make it easier to read.
Code:
Me.Lista.RowSource = "
SELECT tblUnderhåll.UnderhållsID, tblUnderhåll.Uppdrag, tblAvdelning.Avdelning, tblMaskin.Maskin, tblMaskindel.Maskindel, tblUnderhåll.[Datum Planerat], tblUnderhåll.[Svår uppgift]
FROM tblMaskin
INNER JOIN ((tblMaskindel
INNER JOIN (tblAvdelning
INNER JOIN tblMaskinKomboID ON tblAvdelning.Avdelning_ID = tblMaskinKomboID.AvdelningsID) ON tblMaskindel.MaskindelsID = tblMaskinKomboID.MaskindelsID)
INNER JOIN tblUnderhåll ON tblMaskinKomboID.MaskinKomboID = tblUnderhåll.MaskinKomboID) ON tblMaskin.MaskinID = tblMaskinKomboID.MaskinID
WHERE (((tblAvdelning.Avdelning) Like " * " & Forms!frmUnderhållAdmin!kmbFilterAvdelning & " * ")
And ((tblMaskin.Maskin) Like " * " & Forms!frmUnderhållAdmin!kmbFilterMaskin & " * ")
And ((tblMaskindel.Maskindel) Like " * " & Forms!frmUnderhållAdmin!kmbFilterMaskindel & " * ");"
I need to get the sql working before I add the option button. And I cant really get a hang of SQL in access yet, ive read som many diffrent thing how to convert it so head is spinning. Change to "'*'" or % or "%" for a wild card. But the wild card is a value from a combo box if that is to any help. There might be some better ways to add that maybe. now is it *[combo box]* to sort out values from the list.