setting a value to a field for all records

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

Guest

I need to create 'Select All' and 'Unselect All' buttons to put true or false
in a yes/no field. Anyone have an idea for the easiest way to iterate
through all the records?
 
Use an update query.
Update to 0 (zero) for No or False and -1 (minus one) for Yes or True.
 
You must log in or register to reply here.

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

Creating Checkbox Fields For Every Record 0
Copy record in one form into a new pop-up form 0
How to activate code within a new record 3
Need combo box to refresh when moving to new record 2017 1
CheckBox returning a Null value - is it a common thing? 4
delete record with blank required field 3
Lookup current record with ComboBox, any changes create new record 3
Update multiple record values from form/query 1

Back
Top