form parameter in SQL-INSERT

[jokobe]

hi ng,

I' using code like this to user SQL-Querys with (forms)
parameters.

Set qdf = db.QueryDefs("my_query")
For Each prm In qdf.Parameters
prm.Value = Eval(prm.name)

Set rst = qd.OpenRecordset(dbopendynset)
But it is not working with INSERT or UPDATE.
Any helpful hint?

Thanks in advance

jokobe

 

[Dan Artuso]

Hi,
The OpenRecordset method makes no sense with action queries
because they do not return a recordset.
Use the Execute method instead.