a new question is, how to get the content of my existing query, like the content of "query1" is
"select * from...", i want to sign it to a string.
for example,
...
dim strQuery as string
Me.RecordSource = "Query1"
strQuery = content of "Query1" <-- i don't know how to get it
.....
really thanks
"select * from...", i want to sign it to a string.
for example,
...
dim strQuery as string
Me.RecordSource = "Query1"
strQuery = content of "Query1" <-- i don't know how to get it
.....
really thanks