Enter Parameter Value, on Quit?

[GoinDeep]

My Master Form has a command control "Quit" which triggers DoCmd.Quit on click.

The problem is the user is prompted to enter parameter values before Access will close.

It appears the parameter values support the SQL for list boxes on the
master Form.

Any ideas on how to remove the parameter prompts?

 

[Kodo]

have you tried maybe doing a DoCmd.close on the master form before you quit?

 

[GoinDeep]

have you tried maybe doing a DoCmd.close on the master form before you quit?

KODO, yes I did and still get the promps. I might try assigning some value to the parameters prior to closing/quiting.

 

[JerichoSteele]

Found this link in another thread... http://support.microsoft.com/defaul...kb;EN-US;811860

 

[ScottGem]

My Master Form has a command control "Quit" which triggers DoCmd.Quit on click.

The problem is the user is prompted to enter parameter values before Access will close.

It appears the parameter values support the SQL for list boxes on the
master Form.

Any ideas on how to remove the parameter prompts?

Access prompts you for a parameter value when it encounters an assingment of a value from a field or variable name that it can't find. It then assumes that is a parameter to be be filled in. The parameter box tells you the name. It could be a misspelling or an old field no longer used or something like that. So you need to find that reference and correct it. Some places to look are in Queries, reports, forms, sort orders etc.

HTH
Scott<>