Option group problem

  • Thread starter Thread starter Phil Boorman
  • Start date Start date
P

Phil Boorman

I'm the registrar for my kid's swim club and I am building an Access
database to keep track of our 70 odd swimmers.

I created a form with various fields like name, address etc and a number of
option groups so that I can simply put a check beside information like the
swimmers level. The problem is although filling out the name and address
fields creates a unique form for each swimmer when I tick a check box in an
option box beside the swim level (or similar information) it ends up
applying to every form in my data base. In other words if swimmer A is a D1
level swimmer then that box is checked on the form for everyone in my data
base.

What have I done wrong?

Thanks,

Phil
 
Phil Boorman said:
I'm the registrar for my kid's swim club and I am building an Access
database to keep track of our 70 odd swimmers.

I created a form with various fields like name, address etc and a
number of option groups so that I can simply put a check beside
information like the swimmers level. The problem is although filling
out the name and address fields creates a unique form for each
swimmer when I tick a check box in an option box beside the swim
level (or similar information) it ends up applying to every form in
my data base. In other words if swimmer A is a D1 level swimmer then
that box is checked on the form for everyone in my data base.

What have I done wrong?

Thanks,

Phil
Click to expand...

It sounds like either (a) your option group is not bound to a field in
the form's recordsource table, or (b) your check box is not attached to
the option group, but rather is just an unbound control on the form. If
your option frame contains more than one check box, does it allow you to
have the "D1" box checked at the same time as another check box in the
frame? If so, situation (b) is probably the case. If not, situation
(a) is likely.
 
It sounds like option A is my problem. In fact when I go "view" "field list"
my option boxes do not appear.

Do I have to delete them and start again?

Thanks for the quick response.

Phil
 
Phil Boorman said:
It sounds like option A is my problem. In fact when I go "view"
"field list" my option boxes do not appear.

Do I have to delete them and start again?

Thanks for the quick response.

Phil
Click to expand...

You wouldn't expect to see your option frame or the option controls it
contains in the field list, because that shows only the fields in the
form's recordsource. In other words, it shows data objects, not
user-interface objects. What you need to do is bind the option frame
*control* to a field.

First, you have to actually have a field in your table -- the table the
form is based on -- that is intended to store this information. You
want to store the swimmer's "level", so you should have a field in the
table called "Level" (or some other name that makes more sense to you).
This field should have a Field Type of Number, and a Field Size of Long
Integer or Integer. If you don't already have a field like this in your
table design, make one. (Note: close the form before opening the table
in design view, then make your changes, save and close the table design
before reopening the form).

Then, with the form open in design view, select the option frame to make
it the current control, and click the Properties button on the tool bar.
Go to the Data tab of the property sheet, click on the Control Source
line, and type in (or select from the dropdown list of fields) the name
of the field -- "Level", or whatever you named it.

If the field name doesn't appear in the list, it may be that the form is
based on a query that doesn't include all the fields from the table. If
that's the case, you'll have to bring up the property sheet of the form
itself, and on the Data tab there click on the Record Source line then
on the "build button" that will appear at the end of the line. That
will open the recordsource query in design view, and you can add the
field from the table to the query grid. When you close that and let
Access save your changes, the field should now be available for to use
as the Control Source of your option frame.
 
Thank you very much for such a detailed reply. I had forgotten that all of
the fields on my form originally came from my swimmers table. Hopefully you
have solved my dilemma.

Phil
 
Back
Top