Using string from one form to build query on another?

[David Wetmore]

I have two independent forms. The first uses user input to generate an SQL statement as a string.
I then copy the string into a string on the second form. How, on this second form, can I turn the string
into an SQL statement which I will then use as a rowsource in a list?

As a simplified example, I could have a textbox containing
"SELECT tblTrack.Name FROM tblTrack WHERE (((tblTrack.Name="Track45"))

How do I turn the string into a query to use as a row source for a listbox?

Thanks, Dave Wetmore

 

[David Wetmore]

Thanks, worked like a charm, just like most things that seem obvious once they're pointed out.