Frames

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

j1eggert - 30 Jun 2005 17:16 GMT

I have created three frames on my form that consist of radio buttons (range
from 3 to 5 on each). I have gone into properties and mached the Name to the
Control Source. Do I need to list each radio button in Properties for the
Frame? And, if so, what field do I list them in?

Reply to this Message

fredg - 30 Jun 2005 18:59 GMT

> I have created three frames on my form that consist of radio buttons (range
> from 3 to 5 on each). I have gone into properties and mached the Name to the
> Control Source. Do I need to list each radio button in Properties for the
> Frame? And, if so, what field do I list them in?

There is no need to match the Name of the Option Group to the name of
the field it is bound to. By default, Access names option groups as
"Frame1", "Frame2", etc. That is fine and there is no need to change
it.
Howevver, if you do want to rename it, give it a name that has some
meaning, such as "ShippingOptions", or "PaymentOptions".

Make sure the Option Group's Control Source is set to the field in the
table it is bound to.

The individual radio buttons, if part of the option group, need no
changes, unless for some reason you wish to change their values.
Normally, the radio buttons values start at 1 and go up by one for
each additional button in the group. The value of the Option Group is
the value of which ever radio button has been clicked.

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message

j1eggert - 30 Jun 2005 20:09 GMT

Thank you, that helps. I have one more question. In the Table I have the
Frames data type set to OLE Object, is this the correct data type to use for
frames? And, I test the radio buttons in each frame the other frames go
blank. Do you know what could be causing this problem?

> > I have created three frames on my form that consist of radio buttons (range
> > from 3 to 5 on each). I have gone into properties and mached the Name to the
[quoted text clipped - 16 lines]
> each additional button in the group. The value of the Option Group is
> the value of which ever radio button has been clicked.

Reply to this Message

fredg - 30 Jun 2005 21:01 GMT

> Thank you, that helps. I have one more question. In the Table I have the
> Frames data type set to OLE Object, is this the correct data type to use for
[quoted text clipped - 21 lines]
>> each additional button in the group. The value of the Option Group is
>> the value of which ever radio button has been clicked.

An Option Group returns a number (the number value of the radio button
selected). Set the table field's datatype to Number, Integer Field
Size.

I think you are in a bit of confusion about Frames (or perhaps I am
confused as to what you mean by "Frame").
I think you mean, by using the word Frame, an Option Group, consisting
of several radio buttons. When you click on a radio button that is
part of a Group, only that one is selected, any others in that same
group are de-selected. The Option Group's value is that radio buttons
value, 1, 2, 3, etc. If the group is bound to a field in a table, that
value is saved in that field.
You can have several Option Groups containing it's own set of radio
buttons, but each Option Group must be bound to a different field in
the table. Clicking in one Option Group should have no effect on any
other group (unless you have coded your database to do so, which I
doubt).

If you mean something else by the word "Frame", then I'm at a loss as
to what to suggest to you.

Signature

Fred
Please only reply to this newsgroup.
I do not reply to personal email.

Reply to this Message

j1eggert - 30 Jun 2005 21:11 GMT

Fred:
I changed the data entry to number instead of OLE Object and tested the
form. It corrected the problem. Thanks for your help!

Sincerely,
James E.

> > Thank you, that helps. I have one more question. In the Table I have the
> > Frames data type set to OLE Object, is this the correct data type to use for
[quoted text clipped - 42 lines]
> If you mean something else by the word "Frame", then I'm at a loss as
> to what to suggest to you.

Reply to this Message