This should be easy but?

[Gezza]

Hi, I have a form that on closing comes up with a input box asking for "Enter Parameter Value" for a combobox on the form. How can I stop this from happening?

 

[John Big Booty]

Does the Combo exhibit this sort of behaviour under other circumstances?

 

[Gezza]

Hi John Big Booty, Thank for your reply

Does the Combo exhibit this sort of behaviour under other circumstances?

No only on closing

 

[John Big Booty]

Strange

Any chance you could post a copy of the DB?

 

[ColinEssex]

A more informative title may help people answer your query.

Col

 

[Gezza]

Strange

Any chance you could post a copy of the DB?

I could but I am not sure how to do it?

 

[Gezza]

A more informative title may help people answer your query.

Col

Yes your probably right, lesson learnt. Thank You!

 

[John Big Booty]

This link has step by step instructions.

 

[John Big Booty]

I have coincidently run into a similar situation. Is the combo on a sub form and being populated by a query that has criteria derived from the main form?

 

[Gezza]

I have coincidently run into a similar situation. Is the combo on a sub form and being populated by a query that has criteria derived from the main form?

Hi Again John Big Booty, Thank you, but I have consequently fix the problem I had by recreating the combo box from scratch, (originally I copied and pasted one from another combo box on the same form). Once I had done that the problem has gone. It is now all working fine.

Thanks again

Gezza

 

[John Big Booty]

Good to hear

 

[gemma-the-husky]

does it show this box in other circumstances (eg when saving a record)

when you close a form, access saves the current record. so it it sounds to me like you have a dirty record, and access is doing exactly the same as it does when you move off a record, or save it in other ways. I would suspect something in the forms beforeupdate event/after update event