ACCESS error message

[JC1856]

I converted an ACCESS 97 DB to ACCESS 2000. On one particular page, I click on a button and it returns records. Then I click on any other button on the form and I get the following message: "You can't carry out this action at the present time".

This may be an ACCESS bug. Every other button on any other page when clicked, the message appears.

The layout of the form is a parent form that has a subform which is a datasheet. We only get the error when we first run the query. The records come back and the subform is populated correctly. However, when I try to open another form to add a new record or even return to the previous form, I get the error.

I've already checked to make sure DAO 3.5 or higher libary has been selected and added Dim " as DAO."". I do not think there is a problem related to the DAO/ADO.

When I step through the code, it works as it should.

PLEASE HELP! I'VE EXHAUSTED ALL OTHER RESOURCES!

 

[Carol]

Sometimes when converting or copying gremlins can appear in code even if it is compiled. What may work on one form, presents this error message on another even when things appear correct. The only solution I have found is to delete both the button and the code behind it and create a new button with new coding. This is expecially noticeable in Access 2000.

Good luck.

 

[JC1856]

Thanks, I've tried rebuilding the button already buy I'll try rebuilding the entire form. I'll post any developments.

 

[JC1856]

Redesigned the form and button. Still receiving the error message.

[This message has been edited by JC1856 (edited 06-30-2000).]

 

[Carol]

What does your button, when clicked do. Perhaps if you showed the coding.

 

[JC1856]

ALL-

I need another way to do this:

Me![subfrmCurrentGroupings].Form.RecordSource = "qryGroupSelection"

basically this code displays the results of the query onto a subform.