Replicated ver. won't print

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

The Master(origional) prints fine but the replicated
versions won't print (the origional still prints OK after
creating the replicas). I get a syntax error. The error
occurs in the following line of code:

DoCmd.OpenReport stDocName, acNormal

I copied this code. I'm kinda fuzzy on this DoCmd thing.
The "acnormal" though has a value of "0" in debug.
Can anyone help? CHALLANGE :)

Thanks in advance...Jim
 
The bellow code is not the problem. It's that in the
replicated version, there error is "Missing Operator in
query". The only criteria is if a checkbox in the record
is checked or not. I put "= -1" in criteria, but after I
save it and reopen it has changed to "-1". Is this the
problem? and I would I fix it?
 
I assume the double quotes are only for the post, not what you put in
Access. In this case, it is correct since in the query grid, equal sign is
assume if you don't have a Boolean operator in the criteria row.

Post the SQL String of your Query.
 
Back
Top