MS Access 2007 - DAO method question... rs.update with an option group

Question

I am using rs.update to change some values. something like

rs("SomeField") = frmSomeOptionGroup.value

where I want the actual option value to be stored in the table. however this just simply seems to return true or false values to the table instead of 0-2....

so what should I do to make this concept work?

thanks justin

Answer 1

you should use rs.update with rs.requery

Answer 2

The concept should work. Can you set a breakpoint and check the value of the option group?