I have absolutely no training in VBA, but I have a project on my lap through work that I'm trying to muddle through. I've been using tutorials & internet research to teach myself to use Access, & right now I'm trying to create a report that uses a form to run a parameter.
I'm using code given in a Microsoft Access help article, but when I entered it, I tried to open the report & was brought back into VBA for a code error. I'm not sure if I am misinterpreting the article I'm using, or if there is perhaps a typo in the article, or what--with no knowledge of this code, I could have it one character off & would have no way to know the difference.
I'm hoping someone here can take a look & see if anything jumps out at them? Thanks for your time & help, I appreciate it!
Private Sub Report_Open(Cancel As Integer)
'Set public variable to true to indicate that the report
'is in the Open event
blnReportOpenEvent = True
'Open Select Alpine Program Lookup
DoCmd.OpenForm "Select Alpine Program Lookup", , , , , acDialog
'Cancel Report if User Clicked the Cancel Button
If IsLoaded("Select Alpine Program Lookup") = False Then Cancel = True
'Set public variable to false to indicate that the
'Open event is completed
blnReportOpenEvent = False