Access 2003 - Report asking for parameter value

[GuiGirl]

I am using Access 2003. I have been searching through the many websites for tutorials. They have been useful. My question, I created a report using query builder and it works well. However, since I gave the query a parameter, the report wants to know What Care Option? As the creator I know the care options to use. The end user will not. Is there a way to have a list of care options available to the end user so that he/she would know what to type into the field when asked? Maybe there is a better way to do this report. I welcome advise.

My database has a table with a list of facilities with address, phone number and various codes used by the state to identify licensing. Another table is for Care Options 47 options as a dropdown. My relationships work fine. I just am having a problem with the report?

I thank you for any help in advance.

 

[pbaldy]

Create a form with a combo box listing the options, and a button to open the report. Have the report's query look at the form for the criteria.

 

[GuiGirl]

Thanks for the advice. I will give it a try and let you know. I appreciate your quick response.

 

[GuiGirl]

pbaldy,

Thanks for your advise. The command button and combo box on the form did the trick. Real slick. I will be using this again I am sure.

 

[gissah]

Can this be shared or demonstrated in a snapshot. Thanks

 

[GuiGirl]

A good tutorial is http://www.datapigtechnologies.com/AccessMain.htm Apply a filter to a report using a form entry. A great website.