Manipulating Form&Query Sources

[dinorbaccess]

Hello everyone,



Im facing a problem right now that seems to be simple but I cant find the solution alone. I tried many way but it doesnt work.
Ive attached a sampl of my access file. Its very simplified, just to tell you where is my problem.

So the problem is this.
I have a table where for instance want to enroll students. For this table I have made queries for every month to select the students that are enrolled on specific month.
Then I created a form frmStudent which has a source to these queries.
I want to change the record source of my subform frmStudent which is placed in my main form on Combobox change event. The sources that I want to put in are the queries that I created.
So what I want is, when I click a value on comboBox, first to change the record source of my subform frmStudent and then show it in my subform.

My attach may help to explain my problem.

[pbaldy]

It is a mistake to make queries for each time period you want to query. Also, what are you going to do when you have two years worth of data?. Your combo doesn't allow for year. You want to create what's called a parameter query. It would rely on form controls or some other method to dynamically change the data it retrieved. In that event, you would base the subform on it and simply requery the subform when the combo updates. The easiest method would be to have two textboxes for a date range, and your query criteria would look like:

Between Forms!MainForm.txtFromDate And Forms!MainForm.txtToDate

presuming the two textboxes were named txtFromDate and txtToDate.

[dinorbaccess]

It is a mistake to make queries for each time period you want to query. Also, what are you going to do when you have two years worth of data?. Your combo doesn't allow for year. You want to create what's called a parameter query. It would rely on form controls or some other method to dynamically change the data it retrieved. In that event, you would base the subform on it and simply requery the subform when the combo updates. The easiest method would be to have two textboxes for a date range, and your query criteria would look like:

Between Forms!MainForm.txtFromDate And Forms!MainForm.txtToDate

presuming the two textboxes were named txtFromDate and txtToDate.

Problem solved. Thnx for your idea man.
God bless you

[pbaldy]

Happy to help!