Promted for parameter too early

[Dwight]

Hello all,

I have not posted for awhile but this problem is annoying and I think easily solved. Here tis,

I created a parameter query that retrieves client transactions from a table. The parameters are the ClientID and the StartDate and EndDate. The user should reconcile the transactions at the end of the month so I created a form in datasheet view so they can check them and make any changes.

I created a second form to allow the user to input the ClientID, StartDate, and EndDate fields for the parameter query. I set the 1st form´s Event to open this form On Open.

The problem is that it prompts for the parameters before the it opens the input form.

I am sure there is no old dead code involved. I have completely deleted the forms and queries and started over as well as hunted down all the field names. The queries and forms all work fine it is just this little bug.

What else should I do or check?

Thanks, Dwight

 

[FoFa]

IF I read that correctly, your first form is based on your parameter query, the second is suppose to pass the parameters to the query (basically). The first form is opening first, and is running the query, hence it prompts you. Why not open the prompt form first, then open the (first form) second once a selection is complete?

 

[Dwight]

You read it exactly right.

I had hoped to open the prompt form by setting the Event of the Reconcile Form to open the prompt form On Open. I also tried the Activate or Load choices but they did not work either.

I want it to open the prompt form and THEN run the query with the parameters to pass through to the query. I thought doing it this way would be easy for the user but maybe I am making assumptions about the way Access works that are wrong

Is there another easy way to do a Form on Form setup? My users will never remember to open two seperate forms on their own.

Thanks, Dwight

 

[Dwight]

I am sure this is a common problem so here is how I got around it if will help somebody in the future.

I set up a third form with two command buttons that run macros to open the input form and then the reconcile form.

It works but it seems like there should be an easier way.