I have a form/subform when i get to the last field in the subform I want the cursor to tab back to the first field in the main form and go into data entry mode. so i embedded a macro on the exit event in the last field of the subform and is as follows:
SelectObject - Form, NewInv, No
GoToControl - cta
RunCommand - DataEntry
StopMacro
but then when the data entry is finished and i try to close the form i get the following message:
the object "NewInv isnt open" The macro you are running (directly or indirectly) contains a gotorecord, repaintobject, or selectobject action, but the object name argument names an object that is closed. The objectname argument for the gotorecord, repaintobject, or selectobject method names an object that is closed. Use one of the open actions or methods to open the object so that you can carry out the desired action
So what do I do to eliminate the error message? It appears that Access thinks that I closed the form in error.
SelectObject - Form, NewInv, No
GoToControl - cta
RunCommand - DataEntry
StopMacro
but then when the data entry is finished and i try to close the form i get the following message:
the object "NewInv isnt open" The macro you are running (directly or indirectly) contains a gotorecord, repaintobject, or selectobject action, but the object name argument names an object that is closed. The objectname argument for the gotorecord, repaintobject, or selectobject method names an object that is closed. Use one of the open actions or methods to open the object so that you can carry out the desired action
So what do I do to eliminate the error message? It appears that Access thinks that I closed the form in error.