Access: TExt Box = Combo Box

[gheyman]

I have a Combo Box (unbound) that when its changed, I want another field (a bound text box) to equal what was selected in the Combo box.

I tried versions of these, but its not working (two examples)

Private Sub ComboItemID_Change()
Me.ITEMID = [ComboItemID]
End Sub


Private Sub ComboItemID_Change()
ITEMID = ComboItemID
End Su

These are on a form that's source is a query

 

[welshgasman]

Why do you use Me for one control and not the other?

 

[gheyman]

just trying different things to see what I can get to work.

 

[xenou]

It works for me.

 

[gheyman]

Thanks. Ill try it with the "me" in front of both!