Get value from combobox

[OrlandoG7]

I have a combobox tied to 2 fields on one table. the row source is: SELECT [tblBoats].[ID], [tblBoats].[BoatName] FROM tblBoats;

When selecting a boatname from the combobox, I want the name of the boat to appear in a textbox on the same form.

Private Sub Command16_Click()
Form_frmNewCrs.CruiseRemarks.value = Form_frmNewCrs.BoatName.Value
End Sub

Why won't this work? I get this error:
"Object or class does not support this set of events"

Both controls are text type.

 

[danvlas]

Try this syntax:

Private Sub Command16_Click()
Me("CruiseRemarks&quot = Me("BoatName&quot'.Column(1)
End Sub

Uncomment .Column(1) if you want the second column to be displayed in the text box.

Regards,

Dan

 

[OrlandoG7]

It works. Thanks!