Queries with automatically changing parameters

[Bambini]

I have a very simple action append query with an input parameter in a field.
I would like to automatically change the parameter picking his value from records of a one field table and run the query
on every change.

Thank to every clever guys,
Domenico

 

[MichaelRed]

Hopefully, you do code, because this will need at least a little bit.

Create a query which the fields which hold the criteria.

In a code module, use this query as a record set.

Do a loop, setting the parameter of your 'action append query' to the criteria field.

This is a bit on the "brief' side. If you do code, it should get you started. If not it probably doesn't make any sense, so just ignore it.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over