Brian,
You need to determine exactly what the "action" is that "you can't carry out".
Step through the code, or put some msgboxes in it to find out what is happening, when.
Could be something like you are trying to refresh the subform when it is dirty and its record hasn't been saved.
Or you are breaking referential integrity or something.
The message associated with this error is;
"You can't carry out this action at the present time. You tried to run a macro or used the DoCmd object in
Visual Basic to carry out
an action. However, AppName is performing another activity that prevents this action from being carried out now.
For example, no actions on a form can be carried out while AppName is repainting a control or calculating an expression. Carry out
the action later."
--
Hope This Helps,
Jeff Davies
Quote:
> I can't find any documentation that describes this error code. Basically,
> it says "you can't carry out this action at the present time", and you can't
> run any vba code after it displays this (it will display this message every
> time you try to run any VBA.). You can't even get in design mode. You
> basically have to do an End Task in order to shut down Access and reopen the
> database.
> I will describe the conditions where I get this error:
> I have a form-A with a continuous subform-B attached to table-B.
> I run some function that adds a record to table-B.
> I refresh form-A and it's subform-B.
> This works great as long as subform-B is not filtered previous to the
> execution of the record-adding function.
> I've tried clearing the filter with vba code prior to the record update,
> but it still gives me the same error. I'm not even 100% sure it's a
> filtering problem, but it only occurs when the subform-B is filtered.
> any help would be terrific!
> Brian R. Lawton
> Information Services Manager
> Southwest Microwave, Inc.
Runtime Error 2486