By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,800 Members | 1,404 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,800 IT Pros & Developers. It's quick & easy.

syntax to pass a variable when loading a report

P: 13
I'm just trying to pass a variable into a report using vba but I can't seem to get the syntax right. I have

DoCmd.OpenReport "Report", acViewPreview, "", "[Report_query]![sGroup]=" & var

If I put the var in brackets [var] then it acts as a normal param query and works if I type it in. But I want it to send a var name that I get from a list box to automatically run the report.

thanks
Mar 29 '07 #1
Share this Question
Share on Google+
1 Reply


P: 1
I need to pass set of variables which i include in an array in the first form to another form when that application is opened, i am using a one dimentional array. can u give me a method of coding for this?
Mar 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.