Running a parameter query in a macro

[docliv]

Hi all,
This seems like a simple problem, but for the life of me...I'm not able to figure it out...and I feel like I'm missing something simple. What I have is a parameter query that runs fine. It comes up with it's own box that prompts the user for "data1" with an "ok" button and a "cancel" button. Query works fine on it's own, but when I put it in a macro..hitting the cancel button stops the macro and displays a halt message. I want the user to go back to the form and not see the "halt macro" condition box. What am I missing? Thanks in advance for any help

Terry

 

[JeremyNYC]

Terry,

Tell us more:
-Sql to your query
-what fires the macro
-code in the macro (convert it to code and paste that)

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[docliv]

Jeremy,
Converting the macro to code and running that took care of the "problem", thanks for the suggestions.

Terry