MSAccess 2003: A query that picks up a date from an open form suddenly comes up with the error message "3126: Invalid bracketing of name '[forms!frmreports!frmTodate]'." I replaced the query with a copy from an old application. It ran ok. A few hours later the error is being reported again. It happened on my machine with 2 versions of the application and on the user copy of the app.
Here is the bare code:
Set qdf = CurrentDb.QueryDefs(strQuery)
For intI = 0 To qdf.Parameters.Count - 1
Set prm = qdf.Parameters(intI)
prm.Value = Eval(prm.Name) 'evaluate the parameter name
The parameter strQuery returns the 3126 error message.
Any idea what is causing the instability?
Maintainer of legacy MSworks