Requery Error when Entering Design View for a Form

[rjgriffin46]

As indicated in prior posts, I am modifying the Students template for a student & alumni administration database for our non-profit Food Service Training Academy.



After making some changes recently, whenever I select Design View on a specific form (Student Details), a window pops up stating "The command or action 'Requery' isn't available now. The window further states that:

• You may be in a read-only database or an unconverted database from an earlier version of the database
• The type of object the action applies to isn't currently selected or isn't in the active view.
• And finally "Use only those commands and macro actions that are currently available for this database."

After exiting this window, a Macro Single Step window opens with the following info:

• Macro Name: Student List : txtOpen : Onclick : Embedded Macro
• Condition: (blank)
• Action Name: Requery
• Arguments: (blank)
• Error Number: 2046

This form is usually opened via an "Open" button in a list of students form called Student List. It has 5 tabs on it, the last I created & copied 2 queries to it. The form opens in Form view OK and I can switch to Layout view OK. Once in Design view I seem to be able to do go back and forth OK, although often going back into Design view sometimes only the name of the sub-form is displayed and the whole header, detail, grid, and controls etc. do not show.

Further, you can open the Student Details form directly, but now it opens as a datasheet instead of a form. Otherwise, the normal use of the forms, from a user perspective, does not seem to be affected.

This may have begun after I opened the database in Access 2007. I have done all the development in Access 2010.

Any suggestions as to cause and resolution would be appreciated.

[June7]

Rebuilding the form might be easier than trying to find the cause. Could be corruption in which case the cause will never be found. But if the issue continues with a new form, then definitely something messed up. If you then still have issue and want to provide db for analysis, follow instructions at bottom of my post.

[ranman256]

Did you go to the code and do a find (Ctl-F) on 'Requery' to find the culprit?

[rjgriffin46]

I'm not sure where the code is.

[June7]

You don't know how to open the VBA code editor?

Of course, if you are using macros and don't have any VBA code, a search in VBA editor is not relevant.

[rjgriffin46]

I think I found the Macro, but I am not sure what to make of it. It appears to open a form from a cell on a row of another form. I don't seem to be able to copy it. If you are interested, I could paste screen copies into a spreadsheet and attach to this post.

Thanks

[Xipooo]

Sounds to me like a requery call is running when the form closing or unloading event is being called.

[June7]

Or could provide db. Follow instructions at bottom of my post.