Problem in adding key value pair in combo box using RowSourceType as Value List

[nayal_access]

I am creating a form in access. In the form there is a combobox in which I am adding items using RowSourceType as Value list and Row Source as Male;Female. What I require is whether there is some way so that when I select Male from combo box M is stored in database and with Female F is stored. I know how to achieve this with RowSourceType as Table/Query but not with RowSourceType as Value List. Please suggest me some solution

 

[Pat Hartman]

Welcome aboard

When you create the value list, include the value you want stored.

"M";"Male";"F";"Female"

Change the column count to 2
Leave the bound column as 1
Change the Column widths to 0";1" to hide the first column.