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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.

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

John W. Vinson[MVP]
 
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]

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)
 
Back
Top