Forms - Radio buttons

[Sheba]

hi June7. thank you for your posts. I unbound the optiongroup controls and already set Me.OptionGroup = Null but yes, I bound the check boxes to fields...shouldn't I? how will the values represented by the check boxes be posted to the right table fields..? Please advise

[Sheba]

also, when I check any ofthe options in a particular group, I get error '3032': Cannot perform this operation what could be wrong? all the other checkbox groups are fine when I check them

when I click on debug, I'm taken to this line of code: Me!ASAWhy = Choose(Me.Frame23, "Allergy", "UGIB", "GCS<8")
For the life of me, I can't figure out why

[June7]

I would think the checkboxes should be bound and not within an option group.

What data type is ASAWhy?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Sheba]

Okay thanks but the other checkbox OptionGroups are fine only this pesky one.
The data type (in table) is text. Its display control is Listbox and row source type is value list... I'll strip it down and upload if you still require it

[June7]

I don't understand what you are doing. If the control is a listbox, why do you use code referencing a frame to save value?

[Sheba]

on the table I made it a list box because I was going to provide a list of options to choose from but on the form, the options are represented by check boxes ("Yes" "No" "Undetermined") in an options group

[Sheba]

here is the stripped down copy. I hope it attaches properly

[June7]

I don't see a field ASAWhy as shown in post, I see [ASA] and [why]. ASA has listbox settings for ("Yes" "No" "Undetermined") and [why] has ("Allergy";"UGIB";"GCS<8"). [why] is used in the actual code.

[why] is set as a multi-value field. Cannot add data to a multi-value field with the code you have. If you want this to be a multi-value, use listbox/combobox or more complicated code.

I NEVER use multi-value fields.


BTW, correct spelling: oxygen - 'Oxigine was given by:'

[Sheba]

Hi June7 thank you so much. I guess I was almost getting cross eyed from staring so long at my screen. That was an error and I've recreated the field without multiple values. Also, the name was ASAwhy previously but in desperation I changed it to why. I was trying different things in the hope that the pesky bug would go away. I couldn't tell why the other check boxes were okay and this one wasn't. It pays to have a fresh set of eyes look at your work.

I've also corrected the wrong spelling. A million thanks

[Sheba]

dunno how to flag my post as SOLVED, sorry

[June7]

Thread Tools dropdown above first post.

[Sheba]

roger that