Project Selection for Backend Data (1 Viewer)

[JuniorWoodchuck24]

I've developed a database that starts with a user login and then allows the user to select a project number. The project number is then used as an OpenArgs to concatenate with a string to form a table's name. I'm having a syntax error with the following code:


Tables:
OverallProjectReport-101
OverallProjectReport-102

Forms:
ProjectList (user selects proj number 101/102/etc and makes OpenArgs = to that number)
StartPage (Has all the reports/forms for user)


Problem area:
Defined on Start Page VBA is StrProj as following:
StrProj = "OverallProjectReport-" & Me.OpenArgs
DoCmd.OpenReport "OverallReportView1", acViewPreview, StrProj

 

[twoplustwo]

Try Debug.Printing the Me.OpenArgs in break mode and tell us what you get

 

[JuniorWoodchuck24]

It gives me the following:

"OverallProjectReport-101" for the StrProj value and gives me an 3011 Error

 

[twoplustwo]

Is that the name of a query in the db?

"FilterName is optional. A string expression that is a name of a query in the database" - does this apply to tables too?

Edit: Also references a query at the bottom of the page: http://msdn.microsoft.com/en-us/library/aa220304(office.11).aspx

 

[JuniorWoodchuck24]

The filter is used due to what is in the Table:

OverallProjectReport (Table)
OverallProjectReportConvert (Query that converts table info)

So user can select a conversion report if they wish

That's why I use the filter statement. The OpenArgs is pulling in the correct number based on which project I select 101 for 101 and 102 for 102.