R redblaze Registered User. Local time Today, 22:26 Joined Jan 12, 2002 Messages 54 Jan 30, 2002 #1 hi, how can i make what ever is selected in a combo box, duplicated into a text field? thanks for your help.
hi, how can i make what ever is selected in a combo box, duplicated into a text field? thanks for your help.
J jwindon Registered User. Local time Today, 22:26 Joined Aug 12, 2001 Messages 531 Jan 30, 2002 #2 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.
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.
R redblaze Registered User. Local time Today, 22:26 Joined Jan 12, 2002 Messages 54 Jan 30, 2002 #3 the code above dosent work. there is an error, is there any other way?
J jwindon Registered User. Local time Today, 22:26 Joined Aug 12, 2001 Messages 531 Jan 30, 2002 #4 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
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