Clear Checkbox field on close of form or close of report

's Computer Specifications

good day,

I have a form that I use to print lables for my products. on the form
there is a checkbox (printlabel) and if it is checked then my labels report
will print for those products, and I would like to when the report is closed
then the checkboxes that are true are cleard to false.

I have tried on my report close:

If Me.printlabel = true then
Me.printlabel = false
End if

however its not working, any ideas?

Thanks,

Brook

's Computer Specifications

Consider running an update query:

Dim strSQL as String
strSQL = "Update tblNoName Set PrintLabel = 0"
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True
--
Duane Hookom
MS Access MVP
--

"Brook" <(E-Mail Removed)> wrote in message
news:63F7AB2A-1090-4A0B-8681-(E-Mail Removed)...
> good day,
>
> I have a form that I use to print lables for my products. on the form
> there is a checkbox (printlabel) and if it is checked then my labels
> report
> will print for those products, and I would like to when the report is
> closed
> then the checkboxes that are true are cleard to false.
>
> I have tried on my report close:
>
> If Me.printlabel = true then
> Me.printlabel = false
> End if
>
> however its not working, any ideas?
>
> Thanks,
>
> Brook

's Computer Specifications

Thanks Duane,

that worked great...

Have a great day..

Brook

"Duane Hookom" wrote:

> Consider running an update query:
>
> Dim strSQL as String
> strSQL = "Update tblNoName Set PrintLabel = 0"
> DoCmd.SetWarnings False
> DoCmd.RunSQL strSQL
> DoCmd.SetWarnings True
> --
> Duane Hookom
> MS Access MVP
> --
>
> "Brook" <(E-Mail Removed)> wrote in message
> news:63F7AB2A-1090-4A0B-8681-(E-Mail Removed)...
> > good day,
> >
> > I have a form that I use to print lables for my products. on the form
> > there is a checkbox (printlabel) and if it is checked then my labels
> > report
> > will print for those products, and I would like to when the report is
> > closed
> > then the checkboxes that are true are cleard to false.
> >
> > I have tried on my report close:
> >
> > If Me.printlabel = true then
> > Me.printlabel = false
> > End if
> >
> > however its not working, any ideas?
> >
> > Thanks,
> >
> > Brook
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Close button on a form will not close form - error 2585 - action cannot be carried out while processing a form	Angus Comber	Microsoft Access	2	19th Jul 2006 12:21 PM
Clear a yes/no check box on form close. should be easy..	=?Utf-8?B?QnJvb2s=?=	Microsoft Access Form Coding	2	8th Feb 2006 06:56 AM
Close database - clear form?	=?Utf-8?B?ZGFsYXc=?=	Microsoft Access	0	3rd Feb 2006 03:55 PM
Update Record Field on Report Close	Brook Estes-Beard via AccessMonster.com	Microsoft Access Reports	2	12th Apr 2005 05:01 PM
How to close a userform in a forusers, close protected form?	De Wilde Eddy	Microsoft Excel New Users	1	7th Jun 2004 06:58 PM