Option Group Error

[Subwind]

Hello all. I am having an issue with an option group I am trying to create.

When I first open the form and click an option, I get an Application-Defined or Object-Defined error message. I can then click it again to store the data and get no error message. I can move through all my records and not get the issue again until the form is closed and then reopened. I then get the issue again on first click, and it then goes away. Has anyone every encountered this before?

 

[isladogs]

Hello and welcome to AWF.
What is the code used for the option group items?

 

[Subwind]

Hi Ridders, I have not used any code. I used the option group wizard in access 2016.

 

[isladogs]

Ok let me ask a different way. What does the option group actually do?
And have you tried removing it and making it once again?

 

[Subwind]

I just want a yes or no option stored in a data field. I have tried deleting it a few times. When I do not bind it to a data field it works, it only errors when storing data

 

[isladogs]

I just want a yes or no option stored in a data field. I have tried deleting it a few times. When I do not bind it to a data field it works, it only errors when storing data

Option groups are used where you want an action to occur on clicking a button e.g. open a form or report filtered to the option group choice.

I don't understand how you are trying to use it

Suggest you do a google search on typical uses for option groups. For example
http://www.databasedev.co.uk/option_group_filtering.html

 

[missinglinq]

...When I first open the form and click an option, I get an Application-Defined or Object-Defined error message. I can then click it again to store the data and get no error message. I can move through all my records and not get the issue again until the form is closed and then reopened. I then get the issue again on first click, and it then goes away. Has anyone every encountered this before?

This sounds to me like a problem with the Form, itself, rather than the Option Group...maybe some form of corruption of the Form.

Is the Form too complicated to be easily recreated?

Linq ;0)>

 

[Pat Hartman]

Is your bound field numeric?

 

[Subwind]

I shall try to rebuild the form. The bound field is a Yes/No and the option values I have given to my group are -1 for yes and 0 for no.

 

[Subwind]

This sounds to me like a problem with the Form, itself, rather than the Option Group...maybe some form of corruption of the Form.

Is the Form too complicated to be easily recreated?

Linq ;0)>

You were right, the error is form based. When I rebuilt it on a new form, no error. Strange...

 

[missinglinq]

The Form was obviously corrupted! Glad you got it fixed!

Good luck with your project!

Linq ;0)>