G Guest Jul 22, 2005 #1 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.
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 Jul 22, 2005 #2 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]
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 Jul 23, 2005 #3 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)
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)