Header to affect every detail item

  • Thread starter Thread starter Cathy
  • Start date Start date
C

Cathy

I have a checkbox in the form header, that when checked I
would like it to check the checkbox on every line of
detail in the detail area.

I have been able to get it to check the first line of
detail by using a setvalue command in a macro... but not
every one. How do I go about affecting all of them?

Thank you,
Cathy
 
Cathy,

Use an Update query to check the checkbox on every line of detail in the detail
area. Your code would look like:
DoCmd.SetWarnings False
DoCmd.OpenQuery "NameOfUpdateQuery"
DoCmd.SetWarnings True
Me.Requery

You would run this code in the AfterUpdate event of the checkbox in the header.
 
THANK YOU!

It worked perfectly!

Cathy

-----Original Message-----
Cathy,

Use an Update query to check the checkbox on every line of detail in the detail
area. Your code would look like:
DoCmd.SetWarnings False
DoCmd.OpenQuery "NameOfUpdateQuery"
DoCmd.SetWarnings True
Me.Requery

You would run this code in the AfterUpdate event of the checkbox in the header.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com





.
Click to expand...
 
Back
Top