Change Query's SQL

[Patrick Graham]

O.k. I have an existing saved query called TEST1.

Test1's SQL coding is saved as SELECT * tblClients

How can I code a button once clicked that would change
the Query TEST1's SQL code to SELECT * tblaccounts.

This is a small part of a larger task so it might not
make much sense at the moment, but please help this is
killing me.

 

[Duane Hookom]

CurrentDb.QueryDefs("Test1").SQL = "SELECT * FROM tblAccounts;"

 

[Patrick Graham]

Thanks, figured it was somehting obviosu like that
sleep sooo important.