- Joined
- Dec 13, 2011
- Messages
- 1
- Reaction score
- 0
I am creating a library database and wish to base a report on a query that is based on criteria selected by a combo box if that makes sense?
I would like to have a combo box on a form to select a student and from that somehow create a new query using that student name as criteria to find all the loans that student has made. And then previewing a report based on that query.
There are too many students and the list is updated regularly so I do not want to create a new query for each individual (if possible)
Any ideas would be much appreciated thanks
I would like to have a combo box on a form to select a student and from that somehow create a new query using that student name as criteria to find all the loans that student has made. And then previewing a report based on that query.
There are too many students and the list is updated regularly so I do not want to create a new query for each individual (if possible)
Any ideas would be much appreciated thanks