Dropdown - bestemt

You cant get access to save columns from two combo's automatically!
You can for example have some code in the forms BEFORE UPDATE event.

Me.ID = me.combo1.column(1) & me.combo2.column(1)

or something like that

column(1) - er det en parameter jeg kan/skal ændre på?

Adresserne der bliver vist i combo2, skal kun være adresser der opfylder kravet fra combo1.

If I understand the problem correctly you want to only show data in combo2 depending on what you have chosen from comb1! To do this you will have to modify combo2 RowSource property!
You can do this in the AFTER UPDATE event.

Correct!

is this something you can do yourself? If not I will take a look for you if you send it to dktebrsa@europe.lego.com

Jeg ved det ikke? Hvordan skal det modify?

example:
Dim sSQL As String

    sSQL = "SELECT DISTINCTROW [tblCbo2].[ID], [tblCbo2].[fld1], [tblCbo2].[fld2] FROM [tblCbo2]"
    sSQL = sSQL & " WHERE [tblCbo2].[fld1] = " & Me.Combo0
   
    Me.Combo2.RowSource = sSQL

Hvad er Combo0.

Mit ID er et fortløbende nummer! Gør det noget?

Combo0 is the name of the combo box

OK - Det forvirrer mig bare, at der er Kombinationsboks1 (=Kommune), og Kombinationsboks2 (=Adresse), Kombinationsboks0 (=Adresse) + tblCbo2 (den tabel som data til kombinationsboks2 hentes fra)

Mine koder ser således ud, er de rigtige? Min AdresseID er et Autonummerings felt:

Private Sub Kombinationsboks44_AfterUpdate()
Dim sSQL As String

    sSQL = "SELECT DISTINCTROW [Adresse].[AdresseID], [Adresse].[Gade], [Adresse].[KommuneID] FROM [Adresse]"
    sSQL = sSQL & " WHERE [Adresse].[Gade] = " & Me.Kombinationsboks44
   
    Me.Kombinationsboks44.RowSource = sSQL
End Sub
Private Sub Kombinationsboks46_AfterUpdate()
Me.AdresseID = Me.Kombinationsboks46.Column(2) & Me.Kombinationsboks44.Column(3)
End Sub

shouldnt it be Me.Kombinationsboks46.RowSource = sSQL

Virker ikke! Men det er også fra to forskellige tabeller - Combo46 (KommuneID, By) - Combo44 (AdresseID,Gade,KommuneID)!

Can you sent it to me?

Jeg har prøvet at sende den til dig, Terry, men den kommer ikke igennem!

send it to terry@santhell.dk

rename the dB to .txt or XP will not letit through

xxx>Have you sent anything?

xxx have you received my mail?

Yes. Looks good. Totally forgotten about the points, sorry!

tak :o)