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

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

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


Allen Browne said:
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.

Dosrt30 said:
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!!!!
Click to expand...
Click to expand...
 
Back
Top