View Full Version : Combo = TextBox??


redblaze
01-30-2002, 11:27 AM
hi, how can i make what ever is selected in a combo box, duplicated into a text field?

thanks for your help.

jwindon
01-30-2002, 11:43 AM
On the AfterUpdate event of the combo, put

Me.TextFieldName = Me.ComboName.Column(1)

The columns start at 0. Check your row source to see which column in the combo contains the value you wish to save.

redblaze
01-30-2002, 12:26 PM
the code above dosent work. there is an error, is there any other way?

jwindon
01-30-2002, 12:32 PM
Did you select the code builder and put the code inside the Private Sub and End Sub lines?

Also, add this to the code

DoCmd.RunCommand acCmdRefresh