Option Group Values Not Stored in Table After Selection

[dgj32784]

I’m an Access novice and I’m regularly reminded when the seemingly simplest of things fail to work properly. This is probably something terribly simple, but for some reason an option group value on one of my forms is not stored in the table once the selection is made. The control source appears to be selected correctly. I used the wizard to specify that the value should be stored in the table. Any ideas why my table does not update? I have some programming on the same form that is inserting values directly into the table once a surveyor inputs certain information. I suppose I could do this for the option group as well, but I'm a bit annoyed (at myself) that I cannot get this simple control to behave as intended. Anyone know what I'm doing wrong?

Thanks,


David

[RuralGuy]

Is the Option Group bound to a field? Is the field updateable?

[dgj32784]

Again, excuse my ignorance. I think it is bound to a field - is that decided by the control source? I used the wizard and specified where the value should be stored. What should I check to make sure the field is "updateable"?

[RuralGuy]

Yes, the "bound" field is defined in the ControlSource of the OptionGroup. What is the DataType of the field? Can you open the TecordSource of the Form directly and change that particular field? Is the RecordSource of the Form a table or a query?

[dgj32784]

Thanks RG for your comments. They forced me to look further into what the form was based on and how I was inputting other values on the form. The VBA that I used to "manually" insert a custom primary key into the table as a record was preventing me from editing additional fields associated with that record. I've now reduced my VBA to simply generate the custom ID and place it into the control on the form, which now enables me to enter values or select from option groups to enter values into other fields.

[RuralGuy]

That's great! Thanks for posting back with your success.