a window pops up asking to debug and then gives me these four windows in the attachment can you help me and tell me how to fix please
a window pops up asking to debug and then gives me these four windows in the attachment can you help me and tell me how to fix please
When does this code popup? From Where? Are you needing to Link any Criteria?
Try this:
Dim strReportName As String
strReportName = "Hours By Volunteer"
DoCmd.OpenReport strReportName, acViewPreview, , strCriteria
I don't know what the text of 3071 is offhand, but does the report open from the Navigation Pane without error?
it didn't seem to change anything but i get a preview now which we didn't have before! thanks
Glad you made progress. Debug your app one line of code at a time.
Good Luck!
I don't think using an undeclared variable would help, so I'm guessing something else changed. You might find this relevant:
http://www.baldyweb.com/OptionExplicit.htm