Update query with Option Group Value

[bcofie]

UPDATE Table1 SET Table1.BYear = [Forms]![Form1]![FrameB];




This update query doesnt work. I cant figure out why. Basically I am trying to update a table with the selected value that sits in an frame of option group. Everything thing is unbound--form and frame.
Any help will be appreciated.

[jzwp11]

Does table1 have only 1 record?

[jzwp11]

BTW, when you created the option group did you physically change the control name to FrameB or just the header of the frame that shows up on the form? If you just changed the header, you will have to also change the name of the actual control to FrameB

[bcofie]

I changed option group name to FrameB. Table1 contains 1Field BYear with no record in it.

[jzwp11]

You cannot update a record that does not exist. You either have to add a record manually or change your update query to an append query. An update query only changes existing records, an append query adds new records.

Even if you do not have a record in the table, Access should still attempt the update but will say that 0 records were updated. Are you seeing that message when you attempt to run the update query?

[bcofie]

Yes I do see 0records were updated. That makes sense. I will manually add a record and see how that goes.
Thanks

[jzwp11]

You're welcome. Please post back if you have any other questions regarding the form or query.