Combo Box to Add Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a combo box that is linked to a Table:Customer Info that
has the Custmer # as the first field and Customer Name as the second field.
I have it set so the drop down shows the customer name only. When the command
button to add a new record to Table:Order based on the info selected in the
combo box, the field is populated with the customer # and not the customer
name as I would like. Please help.
 
Even though the first field is not displayed, you still need to refer to the
value you want by the column number

For customer #:
Me.[ComboName].Column(0)
Or
Me.[ComboName]

For customer name:
Me.[ComboName].Column(1)
 
Where do I refer to this value at?
--
Cooper


Ofer Cohen said:
Even though the first field is not displayed, you still need to refer to the
value you want by the column number

For customer #:
Me.[ComboName].Column(0)
Or
Me.[ComboName]

For customer name:
Me.[ComboName].Column(1)


--
Good Luck
BS"D


Cooper said:
I have a form with a combo box that is linked to a Table:Customer Info that
has the Custmer # as the first field and Customer Name as the second field.
I have it set so the drop down shows the customer name only. When the command
button to add a new record to Table:Order based on the info selected in the
combo box, the field is populated with the customer # and not the customer
name as I would like. Please help.
Click to expand...
Click to expand...
 
Back
Top