A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Forms Option Group



 
 
Thread Tools Display Modes
  #1  
Old February 19th, 2010, 06:14 PM posted to microsoft.public.access.gettingstarted
Hendrix[_3_]
external usenet poster
 
Posts: 10
Default Forms Option Group

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?
  #2  
Old February 19th, 2010, 06:52 PM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Forms Option Group

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" wrote in message
...
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?



  #3  
Old February 19th, 2010, 07:09 PM posted to microsoft.public.access.gettingstarted
Hendrix[_3_]
external usenet poster
 
Posts: 10
Default Forms Option Group

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?

On Feb 19, 12:52*pm, "Al Campagna" wrote:
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" wrote in message

...



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?- Hide quoted text -


- Show quoted text -


  #4  
Old February 20th, 2010, 12:48 AM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Forms Option Group

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... ( 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."

"Hendrix" wrote in message
...
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?

On Feb 19, 12:52 pm, "Al Campagna" wrote:
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" wrote in message

...



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?- Hide quoted text -


- Show quoted text -



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.