|
| 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. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 12th, 2005, 02:01 PM
|
|||
|
|||
One Check box to check all check boxes
Hi,
I have a continuous form that is using a table as a control source. Each record has a checkbox, I put an unbound check box in the form header- when I check this box off I want all the check boxes on the form detail to be checked off as well and when I uncheck the check box on the form header I want all the check boxes on the form detail to uncheck. I currently have code for the check box in the form header that says If Me.ckboxAll = "-1" Then Me.ckbox = "-1" Else Me.ckbox = "0" But when I check the box off on the form header only the first check box on the form detail checks. Thanks, Mark -- MSS 
|
|
#2
April 12th, 2005, 03:36 PM
|
|||
|
|||
|
Even though continuous forms show lots of records, only one record is the
current record and thus your code only updates the one current record. You can create a saved update query to update the whole recordset when you click your checkbox and then refresh/requery the data behind your form. "Mark Senibaldi" wrote in message ... Hi, I have a continuous form that is using a table as a control source. Each record has a checkbox, I put an unbound check box in the form header- when I check this box off I want all the check boxes on the form detail to be checked off as well and when I uncheck the check box on the form header I want all the check boxes on the form detail to uncheck. I currently have code for the check box in the form header that says If Me.ckboxAll = "-1" Then Me.ckbox = "-1" Else Me.ckbox = "0" But when I check the box off on the form header only the first check box on the form detail checks. Thanks, Mark -- MSS
|
|
#3
April 12th, 2005, 04:27 PM
|
|||
|
|||
|
Thanks- that worked perfectly.
"Mark M" wrote: Even though continuous forms show lots of records, only one record is the current record and thus your code only updates the one current record. You can create a saved update query to update the whole recordset when you click your checkbox and then refresh/requery the data behind your form. "Mark Senibaldi" wrote in message ... Hi, I have a continuous form that is using a table as a control source. Each record has a checkbox, I put an unbound check box in the form header- when I check this box off I want all the check boxes on the form detail to be checked off as well and when I uncheck the check box on the form header I want all the check boxes on the form detail to uncheck. I currently have code for the check box in the form header that says If Me.ckboxAll = "-1" Then Me.ckbox = "-1" Else Me.ckbox = "0" But when I check the box off on the form header only the first check box on the form detail checks. Thanks, Mark -- MSS
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Adding Check Boxes | Mike R | General Discussion | 2 | February 13th, 2005 03:59 AM |
| how do i check multiple check boxes in access to save me clicking. | smokybeckham | General Discussion | 2 | October 28th, 2004 06:49 PM |
| How to increase the size of check boxes in Access forms/reports? | OutdoorVisions | Using Forms | 1 | October 23rd, 2004 12:55 PM |
| Combo and check boxes move left after printing | Heidi | General Discussion | 4 | September 30th, 2004 07:21 PM |
| Check boxes replaced by exclamation marks! | Tomb. | General Discussion | 1 | June 23rd, 2004 08:00 PM |
Linear Mode
