Option Group Help

[Tansar]

Hi,
I need some advice as to how do I make the Option Group work with each record.

Basically, I created an option group on a form and each time I move through the form the same option is highlighted for all my records

Where am I going wrong?

Hope to hear.

 

[dkinley]

Please only post once and do not start a new thread with the same discrepancy.

1. Create a field in your table that the form is bound to.
2. On the form you want your option group, select the option group tool to start the wizard.
3. The label is for what you choose for your options, suppose here it is "On" and "Off"
4. Choose a default if desired.
5. The Values are values that is the stored data of the option the user has selected (numerical). I usually run with the default.
6. Store the value in the field you created in step 1.
7. Apply the cosmetics
8. Name the option group.

Tips: To change the value, you have to click the properties of the selection control inside the frame.
To change the field the option group is bound to you have to click the properties of the frame itself.

In this example, if the user selected 'On', then my table would have '1' in the field.

Hope that helps.
-dK






-dK

 

[Tansar]

Please only post once and do not start a new thread with the same discrepancy.

-dK

I was trying to find how to delete that thread which I posted again as my connection failed (hence posted again, unintentionally)...

I hope I get a speedy response like this one

 

[dkinley]

The reason you were seeing it across forms is probably because it was not bound to a field.

-dK

 

[Tansar]

The reason you were seeing it across forms is probably because it was not bound to a field.

-dK

Ok. thanks for that.

So there has to be a field in the table for the OG to work then?

Will try it again.

 

[missinglinq]

There has to be a field for the Option Group to be bound to if you want it to retain the value for a given record that you chose, just as a combobox or listbox does.

 

[Tansar]

Thanks for that...

I need to add more options to the group, and I'm kinda blank how to get the dialogue box to enter further options.

TIA

 

[missinglinq]

I don't think you can go thru the Wizard (what you're calling the dialog box) again What you have to do is:

1. Resize the frame so you have room for the new options
2. Click on whatever control you're using, i.e. a checkbox or option button
3. Place your cursor over the Option Group frame until the frame turns black
4. Left click

The control is now part of the Option Group, with the next value available, i.e. if it's the 5th option, its value will be 5.

 

[Tansar]

...
The control is now part of the Option Group, with the next value available, i.e. if it's the 5th option, its value will be 5.

Nice
Thank you.

 

[missinglinq]

Glad to help!

Linq