OpenArgs Statement Not available OnOpen

[flaniganmj]

Howdy All,

I am using a form for selection of data criteria and from that I am building and SQL statemtent in which I was planning on using in the OpenArgs arguement of DoCmd.OpenReport. In the report OnOpen I use Me.ControlSource = Me.OpenArgs. This should work, I am little rusty with Access, as I have not used it in awhile. The OpenArgs is comming accross as Null, and I am getting an 'Invalid use of Null' error. I am doing something very simple wrong. Any help is appreciated.

Thanks,

flan

 

[mp9]

Up until Access 2000 at least, reports don't have OpenArgs properties. At least, you can't specify one in a

DoCmd.OpenReport{/code] command.

As far as I'm aware, up to and including Access 2000 you can only specify OpenArgs for forms. This is a bit rubbish, so hopefully it'll be added in A2002. [pc2] [URL unfurl="true"]http://www22.brinkster.com/accessory/[/URL]

 

[mp9]

Up until Access 2000 at least, reports don't have OpenArgs properties. At least, you can't specify one in a

DoCmd.OpenReport

command.

As far as I'm aware, up to and including Access 2000 you can only specify OpenArgs for forms. This is a bit rubbish, so hopefully it'll be added in A2002.

http://www22.brinkster.com/accessory/

 

[flaniganmj]

I use 'fixed' strings in the OpenAgs, i.e. "Sales Summary" and from there use it in the report caption and txt boxes; so it must not allow me to use a variable string, i.e. mySQL. On the other hand, I know I have used this procedure before and I am very confused. Any other tips on how to pull a report using multiple criteria from a form. Without referencing the object variable in the query or report.

flan