Confused...On Exit Event
Hi All,
I'm having a problem with an On Exit event and it doesn't make any sense to me. I have a form with a couple of subforms. I have a control on one of the subforms, and I want to trigger an event (something simple like docmd.save)when I exit that control.
The main form opens just fine, but when I try to enter data into the first field on the main form, I get a Run-time error '2486' (You can't carry out this action at this time.) I hit the debug button, and it is showing me that the error is in the On Exit event for the subform control.
My 1st question is: even if there is a problem with the code I have in the On Exit event for this control, why is this error being triggered when I'm way up at the top of the main form?
Anyone have any ideas?
Thanks in advance,
Tim
Hi All,
I'm having a problem with an On Exit event and it doesn't make any sense to me. I have a form with a couple of subforms. I have a control on one of the subforms, and I want to trigger an event (something simple like docmd.save)when I exit that control.
The main form opens just fine, but when I try to enter data into the first field on the main form, I get a Run-time error '2486' (You can't carry out this action at this time.) I hit the debug button, and it is showing me that the error is in the On Exit event for the subform control.
My 1st question is: even if there is a problem with the code I have in the On Exit event for this control, why is this error being triggered when I'm way up at the top of the main form?
Anyone have any ideas?
Thanks in advance,
Tim