RunTime Error 3075

[toleafs]

Hi
Any help with the following error will be appreciated. I am receiving Runtime error 3075, missing parameters in query expression. I am using the following code:

.InitialFileName = DLookup("ScheduleNumber", "tblMainRSS", "PackageID = " & OpenArgs) & "_" & DLookup("Division", "tblMainRSS", "PackageID = " & OpenArgs) & ".pdf"

PackageID is a text field.

Hope this makes sense. Thanks

 

[xenou]

Any text criteria would need to be single-quoted in your dlookup function:
.InitialFileName = DLookup("ScheduleNumber", "tblMainRSS", "PackageID = " & chr(39) & OpenArgs & chr(39)) & "_" & DLookup("Division", "tblMainRSS", "PackageID = " & chr(39) & OpenArgs & chr(39)) & ".pdf"