Hello all,

I was wondering if there is a way to create a form to print a report
based on a selection made in a combo box? I want the user to be able to
view/print a report with all records in a table that match the star rating
chosen in a combo box on a form. Here are the 2 tables:

tblHotel:
HotelID (pk)
Name
address
city
state
zip
Phone
Contact
email
RatingsID (fk)

tblRatings:
RatingID (pk)
StarRating
--
Aloha,
Ron A.

Perhaps one of my samples would help:

http://www.btabdevelopment.com/main/...4/Default.aspx


--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________


"Ron A." wrote:

> Hello all,
>
> I was wondering if there is a way to create a form to print a report
> based on a selection made in a combo box? I want the user to be able to
> view/print a report with all records in a table that match the star rating
> chosen in a combo box on a form. Here are the 2 tables:
>
> tblHotel:
> HotelID (pk)
> Name
> address
> city
> state
> zip
> Phone
> Contact
> email
> RatingsID (fk)
>
> tblRatings:
> RatingID (pk)
> StarRating
> --
> Aloha,
> Ron A.