run update query by clicking check box

[MaddiMond]

Hi,

I wondered if it is possible to run an update query automatically by clicking on a checkbox in a form, which would eliminate the need to go to queries and click on the update query.

Thanks,

Maddi

 

[Remou]

Yes. But a command button may be more suitable . If the query already exists, you can use Docmd.OpenQuery. If not, you can build a query; please include some more details, if you want to do this.

 

[Pampers]

yep, using a button is much beter.

Pampers
Just became father!