Checking all..... please I need help!!!!!!

[Guest]

I created a form that has three fields 1. Code, 2, Description 3. Print
(Check Box )

Now when a user opens that form he is able to select (in the Print (Check
box)) the codes that he wants to print.... but my problem is when the user
wants to print a different set of codes he needs to uncheck the ones he
selected before and I don't want that, want the user to be able to uncheck
all and pick his new set of codes....
Any ideas!!!!!!!!!!........ Thanks for your help!!!!

Dorst

 

[Allen Browne]

You can set all records to No in the Print field like this:

Dim strSql As String
strsql = "UPDATE [Table1] SET [Print] = False WHERE [Print] = True;"
dbEngine(0)(0).Execute strSql, dbFailOnError

 

[Guest]

When the form opens you could set the three fields to false - if it is just
a form not based on a query/table or a record? Even if it is a record and you
choose it, you can set the checkbox to false, if that's clear?
--
Thanks - Robin

You can set all records to No in the Print field like this:

Dim strSql As String
strsql = "UPDATE [Table1] SET [Print] = False WHERE [Print] = True;"
dbEngine(0)(0).Execute strSql, dbFailOnError

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I created a form that has three fields 1. Code, 2, Description 3. Print
(Check Box )

Now when a user opens that form he is able to select (in the Print (Check
box)) the codes that he wants to print.... but my problem is when the user
wants to print a different set of codes he needs to uncheck the ones he
selected before and I don't want that, want the user to be able to uncheck
all and pick his new set of codes....
Any ideas!!!!!!!!!!........ Thanks for your help!!!!