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