Parameter query and form field name not recognised Access 2007 (1 Viewer)

[pl456]

Anybody come accross this issue and have any idea how to fix it.

I have parameter in a query forms!frm_whatever!txtwhatever

When I run the query its fine, I close the db when it opens again it pops the parameter box up as though the name of the field is not recognised. If I change the name of the field on the form and in the query it works again. When I close it the same happens again. every time.

 

[pl456]

I Didn't find the actual reason why but managed to get around this by copying and pasting all my database objects into a new blank database.

Might help if anyone has a similar problem.

feel like I am talking to myself at times

 

[Raga32]

I had this exact problem, and copying the database to a new file worked. Thanks I couldn't find an answer to the problem anywhere either.

 

[vbaInet]

Raga32, there wasn't any need of resurrecting an old thread.

REgarding the problem, you always have to make sure that the form is open before opening the query? And it should remain open until you close the query.

 

[Raga32]

The query was running off of a control on the form, so having the form open wasn't the problem. Either way, it's fixed now after copying the objects over to a new database.

Thanks for the reply

 

[vbaInet]

Yes I know that. If the form is not open before you open the query it will simply not work. If the form is closed and the query is refreshed, it will fail.

 

[Raga32]

Ok I see what you mean now, that makes sense in retrospect.

Thanks again

 

[vbaInet]

Welcome to the forum by the way!