S
SpookiePower
I have a mainform with a subform on. On my mainform
I also have a combobox containing names of the 12 months.
When I choose a month in the combobox I want all the
customers from that month to be displayed in the subform,
but I dont know how to do this.
I have made this SQL
SELECT *
FROM customer
WHERE (((customer.month)=Forms!kunder!combomonth));
that select the customers by months.
But I don't know how to use this SQL to find customers by selecting
a month in the combobox, and then shows them in a subform.
Anyone who can help me ?
I also have a combobox containing names of the 12 months.
When I choose a month in the combobox I want all the
customers from that month to be displayed in the subform,
but I dont know how to do this.
I have made this SQL
SELECT *
FROM customer
WHERE (((customer.month)=Forms!kunder!combomonth));
that select the customers by months.
But I don't know how to use this SQL to find customers by selecting
a month in the combobox, and then shows them in a subform.
Anyone who can help me ?