Form SQL insert into

[usselite]

Hello,

At the moment I am building forms. I could write away the forms data away with a conventional way. But I would like to use an SQL query for it. Now I am aware of it that VBA is required to do this. But every time the SQL query seems to be placed in the VBA. I am wondering if its possible to make an reference to an query which is saved in access it self (so the SQL query is not hard-coded).



Example:
Not this:
Dim strSQL As String
strSQL = "... THE SQL STATEMENT GOES HERE ...”
DoCmd.RunSQL strSQL

But like this (somehow):
strSQL = "query1"

[pbaldy]

Try

DoCmd.OpenQuery "query1"

You can also use

CurrentDb.Execute "query1"

but it will stumble over form references.