Form Related Parameter

[Guest]

Good morning,

I have a form which will prompt a user to type in a student ID when the form
is opened.

I use the query parameter, and on the parameter screen, it has OK and Cancel
buttons. When the user clicks on the Cancel button, the parameter window is
closed and it would not take me to the previous form. It stays on the blank
Access window.

What should I do so that it would take the user back to the previous form
when the user clicks the Cancel button?

I tried to insert the macro to open the previous form in the On Close event,
and it didn't work.

Thanks.

 

[Guest]

If I were a guessing man I would guess that y ou are not using the Close Form
command behind the command button CANCEL......Use the DoCmd.Close in the ON
CLICK event of the Cancel Commnd Button.

This should close the current form and move the last one remaining open at
that time.

 

[Guest]

Hi Hansford,

Thanks for your help.

It is not the form that I created to prompt the user for parameter.
Therefore, I will not able to do what you said.

It is a parameter window from the query criteria. I do a similar thing for
one of my reports, and when I click on the Cancel button, it takes me back to
the previous form.

Thanks. Please help.