Continuous Form Option Groups Issue

[Lighty_11]

Hello All,

I have created a continuous form for submitting multiple postal details to a table. The problem I am having is when a checkbox in the option groups is ticked, it also ticks the same option for all entries on the form. I need these to operate independently but I also need to keep the functionality of the option group to only allow one selection.

At the moment, I have left the option groups to enter the data into unbound text boxes but ultimately, these values need to be submitted to the table as below:

Option Group: post_service_check
Unbound Text Box: post_service_option
Table Feild for Data: post_service

I have very simple knowledge of VBA and have used all the forums I can to get this far so any help would be appreciated.


Lighty

 

[VilaRestal]

You need to set the control sources of the frames the checkboxes are in.
At the moment they are unbound so they show the same value for all records.

 

[MStef]

I suggest to make the field (option groups) in the table,
and bound this (from form) with the field in tha table.

 

[Lighty_11]

Simple now you say it, can't believe I completeley overlooked that.

Cheers, Lighty

 

[Lighty_11]

Thanks for your suggestions.....I've moved forward slightly and managed to prevent the option groups from duplicating down the form.

What happens now is that the checkboxes themselves aren't working properly and it's also setting the value my control fields to 0 as soon as one is ticked. I have attached the updated version because I can't explain it as well as some of you will see it.

Thanks again

 

[gemma-the-husky]

i do not think an option group is the right control. an option group implies you have several fields, only one of which can be set.

eg, separate fields for MALE, FEMALE, and UNKNOWN

what you should have is a single field that can take alternative values. eg, a combo box, with 3 choices - MALE, FEMALE, UNKNOWN - so now you just have a single bound control -and you won;t get this problem.

 

[VilaRestal]

i do not think an option group is the right control. an option group implies you have several fields, only one of which can be set.

eg, separate fields for MALE, FEMALE, and UNKNOWN

No, an option group when bound to a field is for a single field that should only take a limited set of possible numeric values.
(It would be bad table design anyway to have multiple Yes/No fields where only one should be yes at any one time. Such things should be stored in one numeric field.)

The different option buttons (or checkboxes, they both work the same way in an option group) assign a different value to the option group, which in turn assigns that value to the field its bound to.

E.g. a Questionnaire where there's question asking 'rate such and such from 1 to 10': you could use an option group for that field with 10 option buttons (many webforms will do this)

 

[VilaRestal]

Lighty

One issue to bear in mind is that in a Yes/No field No has value 0 and Yes has value -1 (minus 1). These will be the values of the relevant checkboxes for option groups bound to such a field

But in this case the problem is the fields are Text fields. Option groups aren't appropraite for that, they only handle numbers. You're going to want lookup tables that convert the text to numbers and vice versa.
Once you have that you would store the data as a number and either an option group or a combobox could be used to select the appropriate number

 

[VilaRestal]

OK I've made the changes
You'll notice this way you don't need any code except behind the 'Clear Options' Button