One more field

[Matizo]

Hi,

How do I change the code below to include one more field in the second combo box i.e. ServiceNo. I want both ServiceTitle and ServiceNo to appear (there are both in the same table).

Private Sub ClientNo_AfterUpdate()
 Me.ServiceNo.RowSource = "SELECT ServiceTitle FROM" & _
                            " tblServices WHERE ClientNo = " & Me.ClientNo & _
                            " ORDER BY ServiceTitle"
End Sub

Cheers!

 

[JANR]

Private Sub ClientNo_AfterUpdate()
 Me.ServiceNo.RowSource = "SELECT [COLOR=#ff0000]ServiceNo,[/COLOR] ServiceTitle FROM" & _
                            " tblServices WHERE ClientNo = " & Me.ClientNo & _
                            " ORDER BY ServiceTitle"
End Sub

Do you even try

Also to see the fileld in your combo set Numberofcoloum-proberty to 2, and adjust the whith to an approporate setting. ( 1cm;2cm) or whatever is best.

JR

 

[Matizo]

Janr... it is a loooong story, all I want to do is to finish this database by tomorrow.

I've tried to use & but not , (yes, I know this is dummy)

Thank you anyway!