CODEWITHSUNDEEP
vbams-accessms-access-2007ms-access-2010
ihorko
ihorko

Reputation: 6945

MS Access ComboBox with own values

In my MS Access application I have table and form Customers which contains Numeric field Status (1- means Active, 2 - Inactive, 3 - N/A)

On the form I need to have combobox with values Active, Inactive and NA, and when user selects any value, 1,2 or 3 value should save into Status field.

When I try to set up [Row Source Type] as [Value List] and [Row Source] as ["Active";1;"Inactive";2;"NA";3], [Bound Column] =2, the combobox shows me needless column with values 1,2,3

When I set up [Bound Column] = 1, it tries to store in table ["Active", "Inactive", "NA"] instead of 1,2,3

Who knows how it's possible to implement, what I'm doing wrong?

Upvotes: 1

Views: 2930

Answers (1)

4dmonster
4dmonster

Reputation: 3031

When you use [Value List] as [Row Source Type] you have to set ColumnCount to right value manually.

ColumnCount = 2

Also hide ID column

ColumnsWidth=";0"

Upvotes: 3

Related Questions