Interactive Form for survey

[Canadiangal]

I would like to create an interactive form that creates a SELECT query with multiple parameters for a survey. Here is the example:


Doctors table
Procedure table
Clinic table

The form must allow the end user to select the doctor (from a dropdown), then the procedure (from a dropdown), from the correct clinic (from a dropdown) and then run it in a report by a quarterly date. Can someone direct me to a tutorial that would show this? I have looked at some examples on the Internet, but I can't say that I fully understand the code behind it and would like to see it explained. The end user is putting the information in from a paper form and then running reports for each clinic (satisfaction survey) and for each doctor quarterly.

Thank you in advance for any help and direction you could give.

[ranman256]

the query , say qsMyReport , in the report would look at the controls on the form.

the query looks like:
select * from table where [doctor]=forms!myForm!cboDoc and [clinic]=forms!myForm!cboClinic and [date] between forms!myForm!txtStartDate and forms!myForm!txtEndDate

[orange]

The end user is putting the information in from a paper form

into an Access form for storage into your database?

It seems the form you are primarily interested in is the one to choose from dropdowns to create various reports. Here is an interesting article from Martin Green re dynamic reports. I'm sure there are some concepts, ideas, code you can adapt.

Good luck.

[HiTechCoach]

See if this example is helpful:


Report Dialog Examples

[Canadiangal]

into an Access form for storage into your database?

It seems the form you are primarily interested in is the one to choose from dropdowns to create various reports. Here is an interesting article from Martin Green re dynamic reports. I'm sure there are some concepts, ideas, code you can adapt.

Good luck.

Thank you for the article