Data macro could not be found

RoyLittle0 · December 26th, 2012, 08:21 AM

Hi,

i am running a modified Northwind Traders database and have come across an error that i have not seen before, when i add a purchase order and select the product, the Macro looks up the item price and insert it in the field, but now it is not working, it is obviously something i have done, but i have been modifying this database for some time and cant see any differences between a working backup and the none working copy, i have made numerous other changes to the database so its not as simple as reverting back to the backup, unless i have to.

Code:

Products.GetStandardCost	{CC671F14-88F5-45BD-BF65-8CB6CA5E1DA3}	-8979	Execution	Macro	The data macro 'Products.GetStandardCost' could not be found.		25/12/2012 17:03:45

PurchaseOrderLineItem : cboProductID : AfterUpdate

Code:

OnError
GotoMacro ErrorHandler
/*Determine standard cost for specfied product*/
If Not (IsNull([cboProductID])) Then
RunDataMacro
Macro Name Products.GetStandardCost
Parameters prmProductID
SetProperty ControlName txtUnitCost
Property Value
Value=[ReturnVars]![retStandardCost]
Else UndoRecord
DeleteRecord
RunMacro
MacroName Utilityies.ErrorAlert

RoyLittle0 · December 26th, 2012, 01:17 PM

If i run the macro from the design view i get the error "The object doesn't contain the Automation object 'cboProductID.'

I have copied the form and macros from my backup, which works to this database and that doesn't work either, so it looks like the fault is not with the form/macro but with something else?