Running SQL from Visual Basic

[The Archn00b]

I'm trying to create a dynamic query, that will change according to user determined parameters.

I'm using conditional logic to define variables using Dim based upon values of controls within an MS Access form. The variables are defined as text strings.

What I need to do is create a variable from the aforementioned variable (adding together text strings) that can be ran as SQL in Access.

So I need to confirm/know

1. how to add text strings together
   
2. and how to execute a variable as SQL.

I've done some reading on the subject and the Microsoft Help pages says I need a Dynaset or a Snapshot to use with an SQL query that contains rows. A Dynaset seems like a better way to go, seeing that it will allow me to edit records that are selected by the query. However, I have no idea how this works! Does it appear as a new window in the form or can I get it to appear as a subform?

Thanks for reading!

 

[Mihail]

how to add text strings together

Dim strA As String, strB As String, strC As String
strA = "This is a "
strB = "concatenated string"
strC = strA & strB
MsgBox strC

and how to execute a variable as SQL

Dim MyVar As String
MyVar = "Here is the SQL"
DoCmd.RunSQL MyVar