Saving values of Options to a table

  • Thread starter Thread starter Newf
  • Start date Start date
N

Newf

I'm a newbie with this Access. I'm using Access 2000 and trying to save the
values of the Option Boxes (English or French). The user must select either
or with the default set to English. I have the option Value fro English set
to 1 and French set to 2. When it is selected on the form it doesn't show in
the table of the query I have ran.

Hope someone can help!!

Thanks in advance.

cw
 
Let me assume the following:

The form is bound to a table or an updatable query (Queries that
pull information from more than one table are typically not updatable).
You are using the Option Group control and letting the wizard create
the option boxes for you.


There should be no issue. Now if the query is not updatable, then that
would cause this issue.

It sounds to me like you created the 2 option boxes by making them
individually by dragging them one by one from the tool bar.

The correct way is to use the option group control as stated above. It
will start a wizard that will setup however as many options as you
want, set there individual values and then set which field in the table
or updatable query you want to store the selected value in.

Once the wizard finishes you should see your options with a frame
around them. The frame is the Option Group. If you look into its
properties, you will see it is what is bound to the database field, not
the option boxes themselves.

Once you create the Option group, if you need to add option boxes, you
can then drop extra option boxes into it from the Tool bar.

If you did set this up this way then your Query is not updateable.
Make sure the Option Group is bound to the right field or even if its
bound at all.

Let me know if this helps
 
WAstarita:
Sorry for not replying sooner due to vacation.

I have this done now. Thanks for that help.

I have the default set 1 = English. So when the form is loaded it has English
selected. When I go to select French = 2; it is like its disabled and won't
let me select it and the selection for the English is deselected and won't
let me select anything.

What could be the problem??
 
Again, it sounds like you are using a non-updatable query to source
the form. Are you having any other issues with other controls?
 
Back
Top