How to modify a query

Topic

New Reply

How to modify a query

Reply | Quote

Replies

Arage,
If you want to use a value in a control on your form as a criteria in a stored query you very often don

Reply | Quote

yes I understand that Claus, but what I meant is that my text control could hold more than one entry to display. If I create a parameter like you mentioned above, it will only accept one value, not more than one like I am trying to achieve.

Reply | Quote

Arage,
Is this a continuation of your post on numerous entries in a textbox? I.e. is what you are asking really how to deal with that in a WHERE clause?

Reply | Quote

in a manner of speaking yes, Claus it is a continuation with the exception that the previous report was all about opening a report not a query. And the applyFilter method of the doCmd object will allow you to specify the WHERE conditon, whereas the openQuery method will not.

Reply | Quote

If you have to do it in VBA I suggest you consider using DoCmd.RunSQL.
Then you are free to compose your SQL stmt as you wish incl. the construction of the WHERE clause you need for your job.

Reply | Quote