Forms Option Group
in [Getting Started]
|
Prev: Combining two fields in a table
Next: marvendas@gmail.com Kit completo deSolenóides ( solenoid ) + chicote Para Câmbio automatico 01M hidramatico Audi A3 Vw Golf gti turbo 76847
From: Hendrix on 19 Feb 2010 12:14 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?
From: Al Campagna on 19 Feb 2010 12:52 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" <hendrix10(a)gmail.com> wrote in message news:6e53968b-a4b2-49b2-9093-8c1546acc349(a)d27g2000yqf.googlegroups.com... >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?
From: Hendrix on 19 Feb 2010 13:09 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" <newsgro...(a)comcast.net> 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" <hendri...(a)gmail.com> wrote in message > > news:6e53968b-a4b2-49b2-9093-8c1546acc349(a)d27g2000yqf.googlegroups.com... > > > > >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 -
From: Al Campagna on 19 Feb 2010 18:48
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." "Hendrix" <hendrix10(a)gmail.com> wrote in message news:216fccaf-d342-4338-9677-959f0a0105e1(a)o3g2000vbo.googlegroups.com... 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" <newsgro...(a)comcast.net> 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" <hendri...(a)gmail.com> wrote in message > > news:6e53968b-a4b2-49b2-9093-8c1546acc349(a)d27g2000yqf.googlegroups.com... > > > > >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 - |