DoCmd.OpenQuery - receiving error that query is not found

[kwagner1]

Hello,

i'm using the following code to execute a query but Access returns an error stating that my query cannot be found. It seems as if a "." is being added to the suffix of my string... WHY???? appreciate any help! (The error i receive states: Microsoft Access can't find the object 'qry MLTF total.'

Private Sub Total_Click()
On Error GoTo Err_qry
Dim MyString As String
MyString = "qry MLTF total"

DoCmd.OpenQuery MyString, , acReadOnly

' exit the subroutine
Exit_qry:
Exit Sub

Err_qry:
MsgBox Err.Description
Resume Exit_qry

End Sub

 

[Joe4]

Try renaming your query removing all the blank spaces from the name. A lot of programming codes do not like blank spaces in names of objects or fields.

 

[kwagner1]

didn't amke a difference. It is being executed form a sub-form.... does that make any kind of difference.... (i wouldn't think so.... but??)