Forms Option Group

[Hendrix]

I have created a Option Group in a form. The form is linked to a query
but I would like the users selection of the Option Group to update a
table. Is that possible?

 

[Al Campagna]

Hendrix,
An OptionGroup delivers a whole number numeric value.
The checkboxes each within the group can be assigned a numeric value.
When a checkbox is selected, the OptionGroup assumes the
associated numeric value.
In your table... involved in the query behind the form... you need
a field that will hold the OptionGroup value on each record.
Include that field in the query behind your form, and assign it to
the Control Source of your OptionGroup. In other words... "bind" that
field to the Option Group.

Check Help in Access on Option Groups
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Hendrix]

Al

I have the option group set up in an original form...I guess I should
explain a bit more.

I am creating a database that will have many forms....
I have a Form that is called All jobs that is based of an Job Table.
The form has an Option Group that when selected updates the Jobs
Table.
I have another Form called Uncompleted Jobs that is based on an
Uncompleted Job Query. The Uncompleted Jobs Form is basically the same
as the All Jobs form but only shows the records where the user
selected "Not complete" in the All jobs table.

I would like to have the user be able to update the job status from
the Uncompleted Jobs Form. This change would be reflected in the
original Job Table.

Is that possible?

 

[Al Campagna]

Hendrix,
I really don't understand...

I have a Form that is called All jobs that is based of an Job Table
The form has an Option Group that when selected updates the Jobs
Table.

Let's start with... (RE: tblAllJobs and frmAllJobs)
Why are you using an Option Group on a form to initiate an update
of a table?
What are your options in that group, and what do they each do?

Filling out information on any AllJob record will update the table when
you
move to another record, or you close the form, or force a Refresh, etc...
More detail please...
--------------
Now, maybe I can do an end run around the unclear AllJobs part of
your post, and address the frmUncompletedJobs issue...

If you have an updateable query, based on tblAllJobs, behind
form frmUncompletedJobs... then... what ever values
you change on that form, when updated by one of the many events listed
above, will be updated to tblAllJobs. You don't have to use the entire
table
against a form.

For example... if I filtered my tblUSA addresses in a updateable query
behind a form... for just Texas records, any records I change on that form
are updated to
the tblUSA.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Al

I have the option group set up in an original form...I guess I should
explain a bit more.

I am creating a database that will have many forms....
I have a Form that is called All jobs that is based of an Job Table.
The form has an Option Group that when selected updates the Jobs
Table.
I have another Form called Uncompleted Jobs that is based on an
Uncompleted Job Query. The Uncompleted Jobs Form is basically the same
as the All Jobs form but only shows the records where the user
selected "Not complete" in the All jobs table.

I would like to have the user be able to update the job status from
the Uncompleted Jobs Form. This change would be reflected in the
original Job Table.

Is that possible?