Button on Form locks up Database

[CandyT]

I have added a button onto a form that runs a macro. The macro runs two queries and also closes the form that the button is in. For some reason, as soon as the queries are processed, the database locks up. The form never closes and I have to shut down the database. Has anyone ever run across such an issue? Do you have any suggestions as to where to start checking for an error?

Candy T

 

[LonnieJohnson]

Have you run the macro without the line that closes the form?

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[CandyT]

I can run the macro with AND without the Close Form piece and from the macro itself, it runs fine. However, I attach that macro to a button on a form, and it locks up. I also tried it with and without Close Form from the button as well and no dice. However, I removed the Echo - Off part of the macro and rebuilt the form from scratch and that seems to have done it. Not sure why that would cause a problem, I thought I had used it that way before.

Candy

 

[missinglinq]

The unpredictabilty of Macros (sometimes they work, sometimes they don't, sometimes they do and don't) is one of the reasons that most seasoned developers advise against using them, preferring VBA code instead.

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin

 

[CandyT]

Now you KNOW that isn't what I want to hear. I am having a tough time learning vba - not sure of the best way to get started. any suggestions?

Candy