I'm wondering how I can base a query on (the rowsource of) a list of values.
I have a list of values and then I want a query with the argument that one field of the query is based upon the values that are also in the list of values and then proceed with the query to do other things.
I hope you understand because I almost don't. I'm Dutch but I'm doing my best.
Until now I've got the following but it doens't work. I've got the query with the criteria:
Like [Forms]![FrmVII]![KzeIII].[RowSource]
the list of values of KzeIII isn't Null so that's not the problem. Can VBA read something like this?
I have a list of values and then I want a query with the argument that one field of the query is based upon the values that are also in the list of values and then proceed with the query to do other things.
I hope you understand because I almost don't. I'm Dutch but I'm doing my best.
Until now I've got the following but it doens't work. I've got the query with the criteria:
Like [Forms]![FrmVII]![KzeIII].[RowSource]
the list of values of KzeIII isn't Null so that's not the problem. Can VBA read something like this?