i've entered some code in the 'On Load' portion of my main form, designed to pop up a confirmation dialog asking the user if they want to run a macro to update the DB's tables with current data from some linked tables. when loading the form, however, i get this message:
in addition, the "Show Help" button on this error message gives the following information:
i don't really understand what this means, to be honest. the same code/macro combo worked perfectly fine on another form i created (and subsequently lost, which is why i'm recreating it). any help would be appreciated, and i can provide any additional information necessary.
The expression On Load you entered as the event property setting produced the following error: A problem occurred while <My Database> was communicating with the OLE server or ActiveX Control.
* The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.
in addition, the "Show Help" button on this error message gives the following information:
This error occurs when an event has failed to run because Microsoft Office Access cannot evaluate the location of the logic for the event. For example, if the OnOpen property of a form is set to =[Field], this error occurs because Access expects a macro or event name to run when the event is fired.
i don't really understand what this means, to be honest. the same code/macro combo worked perfectly fine on another form i created (and subsequently lost, which is why i'm recreating it). any help would be appreciated, and i can provide any additional information necessary.
Last edited: