Query not running through VBA but will if query clicked seperately 1

[omooreirl]

Hi all

I have the code below in my on click event in a form. The append query referenced will not run and I am getting no error alert. When I then go to the database window and manually double clik the query it works with no problems.

My call for the query is simply:
DoCmd.OpenQuery "qryAppStoredBatchesTable"

Thanks
OM

 

[dhookom]

I'm not sure how we can trouble-shoot this without being able to see the SQL view. Are there any parameters?

Have you set a breakpoint or MsgBox "code is running" into your code?

Duane
Hook'D on Access
MS Access MVP

 

[omooreirl]

Duane

Believe it or not - your post solved it for me. I'm trialing code and I had a lot of misc unused code that I skipped with GoTo. Based on your thread I decided to take out all the garbage and hey presto it now works!

Thanks
OM