Set All Checkbox field to True

[anvidc]

Hi All,
how to write a script for a button to select all my checkbox fields




I'm Using MS Access 2000
thank you

[Jim Doherty]

Hi All,
how to write a script for a button to select all my checkbox fields




I'm Using MS Access 2000
thank you

Command Button called 'select all' or something and code behind that as

dim myupdate As String
myupdate="UPDATE tblCustomers SET nameofmycheckboxfield=TRUE;"
DoCmd.SetWarnings False
DoCmd.RunSQL myupdate
DoCmd.SetWarnings True
Me!ListBoxName.Requery

[anvidc]

Command Button called 'select all' or something and code behind that as

dim myupdate As String
myupdate="UPDATE tblCustomers SET nameofmycheckboxfield=TRUE;"
DoCmd.SetWarnings False
DoCmd.RunSQL myupdate
DoCmd.SetWarnings True
Me!ListBoxName.Requery

Thank a lot is working...