Header to affect every detail item

[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

 

[PC Datasheet]

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.

 

[Cathy]

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





.