Sub with with problems ...

[Albano]

Hello,
I have a sub thas accepts as parameters the name of a query to execute, but the problem is that sametimes he run the query and other times don't, someane have a clue of what can be the problem.

Theirs teh sub:

Sub escalaVerão(MyQuery)
stDocName = "" & MyQuery & ""
DoCmd.OpenQuery stDocName, acNormal, acEdit
...
End sub

Thanks.
Albano

 

[jimmythegeek]

This should work:

=====
Sub escalaVerão(strQuery as String)
DoCmd.OpenQuery strQuery, acNormal, acEdit
...
End sub Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[Albano]

Thank's Jim Lunde, i'm going to tray.

Albano