How do I select all records and prefill the check box with a 'Y'

D

Deb Bobyak

When I click on a 'Select All' button I need the check box to prefill with a
'Y' so it will select all records within the form.
 
J

John Vinson

On Fri, 22 Jul 2005 07:51:04 -0700, "Deb Bobyak" <Deb
When I click on a 'Select All' button I need the check box to prefill with a
'Y' so it will select all records within the form.
Click to expand...

What's the context, Deb? You say "the check box" - which checkbox? on
a Form? or where?

John W. Vinson[MVP]
 
M

Mike Painter

John said:
On Fri, 22 Jul 2005 07:51:04 -0700, "Deb Bobyak" <Deb


What's the context, Deb? You say "the check box" - which checkbox? on
a Form? or where?

John W. Vinson[MVP]
Click to expand...

My guess is that you will need to run an update query
doCmd.RunSQL "UPDATE YourTable SET YourField = True;"
then refresh the subform(?)

If I'm right don't forget a button to set them all false.

(And send me candy)
 
Top