Ask Your Question

Revision history [back]

@docbda Following on from what others have said and your last comment when you get error "property or method not found". If you create a Macro that runs from an event, such as a button click, and you use the event argument in that Macro then you cannot run the Macro from the Basic IDE. For example –


Sub test(oEvent)
oForm = oEvent.Source.Model.Parent
End Sub


Is a quick way of obtaining the Form Object oForm. The oEvent Object is passed as an argument to the sub. The source of the event is the Button and the parent of the Button is the Form. If you run this directly from the IDE the Event does not occur so the Macro will fail.