Check box control what is printed on report

[DaHans]

Hi,
I have a database which has information on different locations around the country to which we travel a lot. The form used to set up travel has several rental car and hotel choices along with other local information. Once the form's information is updated I print out a report based on the location. However, I want to print out only the rental car and hotel that is selected (via a check box if possible) rather than all the hotels and rental cars choices on the form.

The form look something like this:
City: Miami
Weather: Sunny
Airport: Miami International
Rental car1: Avis (With a check box next to it)
Rental Car2: Enterprise (With a check box next to it)
Hotel1: Marriott (With a check box next to it)
Hotel2: Hilton (With a check box next to it)

The report is based on a query by city, I want the report to only print the rental car and hotel that is selected.

Thank you all in advance for you help.

 

[SpentGeezer]

Here is a sample:

 

[DaHans]

Thanks Spentgeezer! That is exactly what I wanted to do. I can modify this concept to allow rental car and hotels to be added rather than a set menu but the code works great. If you have another minute, sometimes a destination does not have a rental car, I would like to create a message box that comes up when no rental is selected just to makes sure someone didn't forget. Something like "Are you sure you dont want a rental?" if they click yes then it opens the report without a rental, if no they return to the form.

 

[SpentGeezer]

Try this it has no rental option

 

[DaHans]

Thanks again Spentgeezer, My database is obviously a lttle more complicated than the example but your code and ideas worked awesome. I spent the better half of the day wrestling with Null value errors but eventually got it done.

Thanks again,
DaHans