Synchronized combo boxes & populated text box

[bruno1]

I have 2 synchronized combo boxes named group & Title. The synchronize works perfectly using
Private Sub group_AfterUpdate()
Me.Title.RowSource = "SELECT TitleName FROM" & _
" Title WHERE GroupID = " & Me.group & _
" ORDER BY TitleName"
Me.Title = Me.Title.ItemData(0)
End Sub
I want to populate a text box named price from the choice in the 2nd combo.I´ve tried
Title AfterUpdate()
Me.Price = Me.Title(2)
but I cannot seem to get itto work.Can anybody help please?

 

[TheAceMan1]

How are ya bruno1 . . .

Your setting the rowsource of Title to the single field [blue]TitleName[/blue], which is a [purple]string![/purple] Surely your not expecting to get a price here?

See Ya! . . . . . .

Be sure to see thread181-473997