Enter parameter value

[Guest]

Hi!
I have one form based in conditional query.
When open the form with "Enter parameter value" to write option, if we click
on Cancel boutton, open empty form based in query.

What is we do to close this form, and standby in last position, please?

Tnahks in advance.
an

 

[Guest]

On the form load event you can write the code, to check if the form has any
records, if not the form will be closed

If Me.RecordsetClone.RecordCount = 0 Then
DoCmd.Close acForm, "FormName"
End If

 

[Guest]

Thanks for your reply

Sorry.
I go to try to be more explicit.

I have one unbound MainForm with two subforms: SubForm1 based on Q_SubForm1
and SubForm2 based on Q_SubForm2.
When queries runs, each one makes the one asks.
In this moment, if we click in Cancel, ignores it and it opens in the same o
MainForm with Subforms.
It would like that this did not happen.

an

 

[Guest]

Sorry.

The "form" that I mention is of the proper Access. It does not have access
to button “OKâ€â€¦
What I would liked is to be able to substitute the text in the heading
“Enter to parameter valueâ€.

Thanks.
an