form parameter in SQL-INSERT

  • Thread starter Thread starter jokobe
  • Start date Start date
J

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
 
Hi,
The OpenRecordset method makes no sense with action queries
because they do not return a recordset.
Use the Execute method instead.
 
Back
Top