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.
Click to expand...

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]
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default value 13
Prefill data on a form. 1
Clicking a button will prefill some information in a field 2
Document not prefilling from form 3
Preselect value in combo box 4
Auto Fill for tab control 5
Prefill a new record in a sub form 8
Before Update Event 3

Back
Top