Form Combo Box

  • Thread starter Thread starter Rob Sykes
  • Start date Start date
R

Rob Sykes

Hello, I have a customer information table, on this table
I have a customer type field. I have a customer type table
with 2 fields, an autonumber field (TypeID) and a text
field (residential, commercial etc).

I have a form built off the customer table, and I want to
put a combo box on it that will display the text value
(only) from the customer type field, but store the number
value in the customer information table.
 
You need to do the following
1- in the RowSource property, set the SELECT statement to
select the text field then the typeId
2- set the BoundColumn property to 2
3- set the ControlSource property to the column on the
CustomerInformation Table.
4- set the numberOfColumns property to 2
5- set the columnwidths to n;0 where n is the width of the
comboBox.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top