Option Group Coding

[TomP]

I would like to create a list in the options group where anyone can highlight
and select from the group and open a particular report. What I get is a
compile error/expression and I'm not sure what it is.

docmd.OpenReport "caseload report summary",acViewPreview,,,acWindowNormal,,,

Thank you,

 

[boblarson]

You don't provide commas for missing parameters AFTER the last provided
parameter, you just leave it blank. So, remove the commas after
acWindowNormal and it should work. In fact, you really don't need
acWindowNormal either so just try this:

DoCmd.OpenReport "caseload report summary", acViewPreview
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[TomP]

Thank you for your help ... it works!

You don't provide commas for missing parameters AFTER the last provided
parameter, you just leave it blank. So, remove the commas after
acWindowNormal and it should work. In fact, you really don't need
acWindowNormal either so just try this:

DoCmd.OpenReport "caseload report summary", acViewPreview
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________