How to create a form to print a report from selected data?

R

Ron A.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3 cascading combo boxes on a continuous subform (Version 2K) 2
Combo box selection becomes part of query 1
How do I translate a number to the code in a table it refers to? 2
Populate fields on subform based on what is selected in main form 1
Print Form with selected Records? 1
HELP Form with SubForms 1
HLP! Form Design 5
Open Report with only selected records to print? 5

Top