Me.Dirty Problem

B

Bob

My form has Names with a checkboxes next to them, when I tick the checkbox
those names are printed, the problem is I have to close the form and re-open
it if I make any changes on the check boxes to print the correct selection.
I think I have to have a Me.Dirty somewhere, any help would be good...thanks
Bob
 
S

strive4peace

Hi Bob,

in the code to print, before you print:

if me.dirty then me.dirty = false

this will save changes if any have been made -- and, if not, you won't
get an error ;)

if you don't have code to print, instruct your users to save the record
before printing (CTRL-S or click the diskette icon)

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
B

Bob

Crystal this is my code
Private Sub Command16_Click()
DoCmd.OpenReport "rptWorksheettickedPort", acNormal, , , , "WorksheetList"
End Sub

Thanks Bob
 
B

Bob

Brilliant Crystal worked perfectly, thanks Bob

Bob said:
Crystal this is my code
Private Sub Command16_Click()
DoCmd.OpenReport "rptWorksheettickedPort", acNormal, , , , "WorksheetList"
End Sub

Thanks Bob
Click to expand...
 
S

strive4peace

you're welcome, Bob ;) happy to help

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Top