"You cancelled the previous Operation error"-HELP??

[paulw4]

I have the code below to run a query, that is created from a "fill in the blanks" form. I am now getting the error "You cancelled the previous operation"

Earlier when I got this I closed the database and open it and the query ran, now it does not run. As far as the form is concerened no "cancellati on" was done.

Any ideas, since the message is so generic, I can't find what it is referring to.

Dim db As DAO.database
Dim qdf As DAO.QueryDef
Dim strSQL As String

Set db = CurrentDb
Set qdf = db.QueryDefs("q rytest1")
strSQL = Forms!frmReport sMYO.txtQry
qdf.SQL = strSQL

DoCmd.OpenQuery ("qrytest1")

Thanks for the help!

PW

[nico5038]

I have the code below to run a query, that is created from a "fill in the blanks" form. I am now getting the error "You cancelled the previous operation"

Earlier when I got this I closed the database and open it and the query ran, now it does not run. As far as the form is concerened no "cancellati on" was done.

Any ideas, since the message is so generic, I can't find what it is referring to.

Dim db As DAO.database
Dim qdf As DAO.QueryDef
Dim strSQL As String

Set db = CurrentDb
Set qdf = db.QueryDefs("q rytest1")
strSQL = Forms!frmReport sMYO.txtQry
qdf.SQL = strSQL

DoCmd.OpenQuery ("qrytest1")

Thanks for the help!

PW

I guess the form that's triggering this code is "bound" to a table. Access now thinks you're not storing the changes on this form when you start executing another query.
You can try to use an unbound form, or issue a comand like:
DoCmd.Runcomman d accmdSaveRecord
to force Access to "free" the current record processing.

Nic;o)