Option Group Control using Row source data

[Tuckejam]

Trying to create an option group box that will will use data found in the row source properties the field rather than data from a linked table.
Example


My table (and form) is storing data about sober living homes
House name, address etc and if its a Men's House, or a Women's house.
I do not want to create a new table "House Type" with two records "Men's" "Women's".

So I put the data in the row source property giving me a drop down for that field
But when I create the Option group in the form, it makes me convert the data to numbers for entry to the table
is there a way around this or do i have to create a table with data to use the option group control

[ranman256]

put an Option frame on the form, THIS is what gets the value.
in the frame are the 2 radio buttons.

(and set the option values too; -1 for M, 0 for F) BUT it must be numeric.

a query can convert M to =-1, F = 0
then bind the Option Frame to the field and the options will change with the record.

[davegri]

See if this is what you are looking for:


Here's the DB:

Tuckdrjam-davegri-v01.accdb