Error 2486

[Steve]

"You can't carry out this action at the present time"

I get this after I open a form with a subform. I use a Combobox to sect
a visit that selects certain records on the subform. After I input some
data (in unbound text boxes on my main form), I update the table of the
subform, and one field of the main form. I then hide some fields and
the subform, requery and refresh to update the combobox.

It is here that I get the above error when I try to do anything else
that involves a command button. I have to exit Access to get it to be
functional again.

Help

Steve

 

[Jesse Aviles]

Check that your previous operation had completely finished (that your code has finished the sub
entirely), try clicking the save button on the from toolbar and then the command button.

 

[Steve]

Tried that, still doesn't work...

 

[Andreas]

I suggest you find out which specific operation generates the error.

I am not sure from what you have written but does the data save, do the
text boxes and subform become invisible and the requery and refresh work?

What code is behind the command button generating the error and which
specific line is causing the error? Could it be you are trying to put
the cursor into a textbox that is invisible?

Regards,
Andreas

 

[Steve]

The weird thing is, all the operations work correctly. I can even add a
number of values/lines to my subform table. Sometimes I don't even have
to do the save, just select a value from the combobox (which makes the
subform visible, filtered on the combobox value...) and the app bombs
when I try another command button or even "X" the form. I have to "X"
Access to regain control. The whole thing is strange...

 

[Andreas]

Without seeing what you are doing, I am out of ideas.

If you post the code behind the combo box, someone might be able to spot
something obvious. I believe the problem originates from there, unless
you also got code in the form's close event which causes it to crash
there as well as the use of a command button.

Regards,
Andreas