execute two queries in single CLICK event

[jhargram]

Hi All-- Always I execute one query in single click event. Is it any possibility to execute more then one query in single click event. If yes then how?. Thanks in advance...

[orange]

Use vba,

In Click event
DoCmd.Openquery "query1"
DoCmd.Openquery "query2"


Or if action query

In Click event
db.execute sql1,dbfailonError
db.execute sql2,dbfailonError


where sql1 and sql2 are strings containing the SQL of the respective queries.