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

and

P: n/a
I want a menu in my db with 3 fields from 3 different tables,

Surgery Surgeries
report name Report
Month of Report Month

I put this code in:

If [Surgeries] = "Amlwch" and [Report] = "Surgery Monthly Cost
Reports" and [Month] = "April" then
docmd.Openreport "Amlwch Catalogue"
End if

I was hoping that it would open my report but it just throws error
messages..... where am i going wrong because I need the code to open
quite a number of reports.

Please help
Feb 6 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Elainie

It would appear that the command you are using is correct. I'd suggest
trying to open the report without using the code and check if you still get
errors.

After that, it would be helpfull if you could share whatever error messages
you are getting.

Also, is you have a number of report you'd like to open, have you considered
using the MS-Access Switchboard utility? I think it's pretty cool.

All the best with your project.
Dominic Vella
www.effectivedata.com.au

"Elainie" <El**************@bsc.wales.nhs.ukwrote in message
news:ae**********************************@e23g2000 prf.googlegroups.com...
>I want a menu in my db with 3 fields from 3 different tables,

Surgery Surgeries
report name Report
Month of Report Month

I put this code in:

If [Surgeries] = "Amlwch" and [Report] = "Surgery Monthly Cost
Reports" and [Month] = "April" then
docmd.Openreport "Amlwch Catalogue"
End if

I was hoping that it would open my report but it just throws error
messages..... where am i going wrong because I need the code to open
quite a number of reports.

Please help

Feb 18 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.