We help IT Professionals succeed at work.

Macros not working in database Error message,"Operation must use an  update query".

gigifarrow
gigifarrow used Ask the Experts™
on
I have a database that I didnt make. I have taken over it. I am getting two error messages when I make a decision on a form,"Operation must use an update query". when I hit Okay it displays another error message that says ,"Cant follow the Hyperlink to Macro mcrHypAddVehicleChecks. Please verify the destination.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2013

Commented:
There is not quite enough information here to help with this.  Can you post a database with any sensitive information removed?

Author

Commented:
Sorry I cant . Thanks for your help. I will just have to find another way to make it work.
MIS Liason
Most Valuable Expert 2012
Commented:
The "Update-able Query" message, means just that.

You seem to be trying to run a query that wants to update values, but since the query is non-updateable (Group By Query, ...etc) , it cant.

The second message is related to the first, so you have to fix the first issue...

Was this ever working?

Author

Commented:
It was working then all of a sudden it stopped working.
Database1.accdb
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
With no source tables, the DB is basically non-functional...

Can you post a sample version of the DB that clearly illustrates your issue?
Most Valuable Expert 2012
Top Expert 2013

Commented:
gigifarrow,

What did you do to resolve this?
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Yes,

Please post the actual solution...
Even if it means un-accepting my post and accepting your own post as the solution.

Having the "actual" solution marked as the solution makes it much easier for other members searching here for the same issue, to see what worked...

;-)

JeffCoachman