Me.Dirty Problem

[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

 

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

 

[Bob]

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

Thanks Bob

 

[Bob]

Brilliant Crystal worked perfectly, thanks Bob

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

Thanks Bob

 

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