D
D B Lawson
Guest
I have a report which looks to a query for any records that haven't been printed, defined by a Yes/No in a check box. Once the report opens to view those records not printed already, I run an update query to put a check in those records. Trouble is the update query is executing before all the records are printing so, I'm only getting two records to print but, say, five unchecked ones are checking. The code I'm using is:
DoCmd.OpenReport stRptName, acViewPreview, "tblName", "[fieldName] = 0"
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryUpdate"
DoCmd.SetWarnings True
I'm sure the update query is the problem because if I blank that out, all the records print ok.
Any ideas?
[This message has been edited by D B Lawson (edited 03-25-2001).]
DoCmd.OpenReport stRptName, acViewPreview, "tblName", "[fieldName] = 0"
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryUpdate"
DoCmd.SetWarnings True
I'm sure the update query is the problem because if I blank that out, all the records print ok.
Any ideas?
[This message has been edited by D B Lawson (edited 03-25-2001).]