HI all,
a form contains records with 12 variables for each month of the year. Based on a dropdown list filter on the form header, I want to define on which month the user wants to filter. So if the user selects march from the drop down, the records on the form should be filtered on the variable [march] so the variable to filter on is dynamic and I don't know how to define that in vba? Can someone help?
in sql this would be like "select * from [tablename] where [variablename] = a condition" but how to define a variablename that is dynamic based on a dropdown selection....
Many thanks!
Erik
a form contains records with 12 variables for each month of the year. Based on a dropdown list filter on the form header, I want to define on which month the user wants to filter. So if the user selects march from the drop down, the records on the form should be filtered on the variable [march] so the variable to filter on is dynamic and I don't know how to define that in vba? Can someone help?
in sql this would be like "select * from [tablename] where [variablename] = a condition" but how to define a variablename that is dynamic based on a dropdown selection....
Many thanks!
Erik