Access 2010 Not Recognizing Form

I have created a small purchase order / receiving data base.  The initial screen is a form that shows all current purchase orders.  If a user clicks on one of the PO numbers on that form, they are supposed to be taken to the PO detail form for the PO number that was clicked (using OpenForm macro).  This has worked for several months.  However, today, when I do this action it is prompting me to enter the paramater value of the field I clicked on.  Why is it suddenly not recognizing the form field's value that I'm clicking on?  I am finding that sometimes if I keep playing around with things long enough it will suddenly start working again.  I also have a command button on this form that is supposed to requery it and it also isn't working all the time.

Thanks for your help.
Matt JohnsonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

unknown_routineCommented:
If a user clicks on one of the PO numbers on that form, they are supposed to be taken to the PO detail form for the PO number that was clicked (using OpenForm macro).

Provide the macro
0
Matt JohnsonAuthor Commented:
I copy and pasted from the macro screen what you see below.  Does that help?

<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<UserInterfaceMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application">
<UserInterfaceMacro For="PONum" Event="OnClick">
<Statements>
<Action Name="OpenForm">
<Argument Name="FormName">fPOMasterForm</Argument>
<Argument Name="WhereCondition">[PONum]=[Forms]![fPurchaseOrders].[PONum
</Argument>
</Action>
</Statements>
</UserInterfaceMacro>
</UserInterfaceMacros>
0
Jeffrey CoachmanMIS LiasonCommented:
I see this:
    Argument Name="WhereCondition">[PONum]=[Forms]![fPurchaseOrders].[PONum
...seems be missing the closing bracket ( ] )

So do this
    Argument Name="WhereCondition">[PONum]=[Forms]![fPurchaseOrders].[PONum]
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

Jeffrey CoachmanMIS LiasonCommented:
Also note that if you changed any names, you may also get this error...
0
Matt JohnsonAuthor Commented:
No names changed and the missing bracket was due to my editing of the pasted text.  The actual macro has the bracket.  The issue is intermittent and it starts working without me changing anything in any code or forms or macros.  Is this possibly a corruption issue?
0
Matt JohnsonAuthor Commented:
I mentioned it briefly originally, but the command button the form that is supposed to requery the form to refresh it gives me the error:  "The expression On Click you entered as the event property setting produced the following error:  Object or class does not support the set of events."
0
Jeffrey CoachmanMIS LiasonCommented:
So what error are we investigating?

The parameter prompt, or this new error?
0
Matt JohnsonAuthor Commented:
I'm thinking they are connected.  Ultimately the issue is the parameter prompt, but I thought the second error might be an additional clue.
0
Jeffrey CoachmanMIS LiasonCommented:
Again the parameter prompt typically shows up because a name was changed somewhere.
In other words, Access sees something new... It does not know what it is, so it prompts you for the value.
0
Matt JohnsonAuthor Commented:
I can see where that could be the issue, but I can't find anywhere that I changed the PO header form or PO number field name and it does not consistently give me this error as shown in the scenario I just uncovered below:

If I type in the PO number parameter value on the prompt it continues to the PO detail form correctly , but when I attempt to return from the detail form to PO header form it gives me a runtime error saying the "object or class does not support the set of events".  I press the debug option and it takes me to a line of code that is attempting to requery the PO header form that is giving me the issues.  From the VBA screen, I press continue and this time the requery seems to work without issue.  At this point, if I now select one of the PO's off the PO header to see the detail, everything works just as it should with out issue and I see no more prompts to enter the PO number.  What would cause this issue initally when I first open the database but then make it go away when I go through the scenario above?
0
Jeffrey CoachmanMIS LiasonCommented:
Again, you get this prompt when Access does not know what something is...

Without having access to the db, it is difficult to say.

Have you run the compact/repair utility lately?
Is this a simple form,...? If so, try recreating it...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Matt JohnsonAuthor Commented:
We hit busy season in the middle of this issue, so I worked around it.  Finally got back to it and the above suggestion gave me the idea of saving a copy of the data base, swapping names with the original database and then re-trying the copied & renamed database.  That took care of things.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.