Form Combo Box

[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.

 

[Gerald Stanley]

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

 

[Guest]

If you need to know it's Access 2000