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