Combobox and subform

[SpookiePower]

I have on my mainform a lot of textboxes and a subform.

I have now put a combobox on my mainform from which I can
choose the different months of the year. I now want this
combobox to connect to a new subform that I have put on
my mainform, and in this subform I want to show all the custemors
from the different months that I choose in my combobox.

I have tryed different things, but I can't get it to work.

Someone who can help ?


www.photo.activewebsite.dk

 

[SpookiePower]

I have made this SQL

SELECT *
FROM custemor
WHERE (((custemor.month)=Forms!kunder!combomonth));

that select the custemors by months.

But I don't know how to use this SQL to find custemors by selecting
a month in the combobox, and then shows them in a subform.