OK. I created a command button. On "click" I used the following line to preview the current record on a report called "Event Detail Report".
Code:
DoCmd.OpenReport "Event Detail Report", acViewPreview, , "ID=" & Me.ID
So far so good.
Only one major hurdle seems to remain and I think this database will be ready for use. The hurdle is that when I print a report it only shows records which have information in the relevant tables which the subforms are based on.
For example:
Let's say I want to print a list of all health fair events the organization attended in 2014. I open up the form "Switchboard", and choose the relevant filter fields to open a form called "Main Events Form". "Main Events Form" opens and shows a list of events attended in 2014. "Main Events Form" gets its data from a query called "Main Events Table Query" which queries data from a table called "Main Events Table".
Within "Main Events Form" is a subform called "Event Days Table Form" which contains all the days that the event was held on. Event Days Table Form" gets it's data from the table "Event Days Table". Within "Event Days Table Form" is another subform called "Event Volunteers Table Form" which lists all the volunteers who worked an event for that particular day. "Event Volunteers Table Form" gets it's data from the table "Event Volunteers Table".
So here's the hitch. If I open a record in "Main Events Form" which has no information in the subforms, and try to preview or print "Event Detail Report" the report will be blank.
Let's say I want to print an event report on an event called "Bob's Health Fair". Let's say we did not attend "Bob's Health Fair". All the basic information on the health fair exists in the table "Main Events Table" such as date, sponsor, location, setup time, etc. But since we didn't attend the health fair there is no information in the "Event Volunteers Table". Therefore the report showing "Bob's Health Fair" comes out completely blank, even though there is info in the "Main Events Table" on it.
What I want to do is have the report print the basic event information from the table "Main Events Table" even though the fields from "Event Volunteers Table" in the report will be blank. Is there a way to set things up to do that? I've attached a copy of my database below with some bogus sample information entered if that will help.
Thank you.