how to show query result in form without popup parameter

[ausama.ly]

welcome all


how to show query result in form without popup parameter .
Database1.zip

[John_G]

The command6 button on the search form closes the form "Search" before it opens the form "formQ". FormQ has query1 as its record source, but Query1 refers to the form "Search" which is no longer open, so it has to prompt for the value.

A solution is to minimize (DoCmd.Minimize), but not close, the "Search" form before opening FormQ.

[June7]

Other options are to not close Search form or close after opening FormQ.

DoCmd.OpenForm "formQ"
DoCmd.Close acForm, "formQ", acSaveNo

[ausama.ly]

The command6 button on the search form closes the form "Search" before it opens the form "formQ". FormQ has query1 as its record source, but Query1 refers to the form "Search" which is no longer open, so it has to prompt for the value.

A solution is to minimize (DoCmd.Minimize), but not close, the "Search" form before opening FormQ.

Other options are to not close Search form or close after opening FormQ.

DoCmd.OpenForm "formQ"
DoCmd.Close acForm, "formQ", acSaveNo

Thanks for replay ,
I will correct and tell you the result .

[June7]

Ooops, my suggested code should be:

DoCmd.OpenForm "formQ"
DoCmd.Close acForm, "Search", acSaveNo

[ausama.ly]

solved ...
Thank you .