Frames

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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.
 
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?
 
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?
Click to expand...

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.
 
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.
 
Back
Top