Form Error (1 Viewer)

[Sarah.M]

Hi, Plz note, My VBA is disabled for security reason.
I can use only Expression builder, Macros, Queries, Tables, Forms and Reports only.
------------------------------------------------
If I open the form I got this error message "1 errors occurred when you loaded the form" I tried to open in design view same message came to me, I could not open it at all
plz help me to fix it

 

[June7]

Would have to review db so if you want to provide it, follow instructions at bottom of my post.

 

[Pat Hartman]

If the form is based on a querydef, try opening that. It might be causing the error.

 

[Sarah.M]

If the form is based on a querydef, try opening that. It might be causing the error.

I tried but it didn't work
Plz help

 

[CJ_London]

if you can't open the form in design view, implies you have a corruption in the form. Since you can't use VBA it is unlikely you can recover it, but you could try compact/repair. Or create a new db and try to import the form. If you can then open in design view, delete the original form and import back the one you can open.

Another alternative is to import the form from a backup

If you can open the form, review any macros triggered when the form is opened - form open, load, resize, activate and current events. See this link for order of events

Order of events for database objects - Microsoft Support

support.microsoft.com

 

[CJ_London]

I tried but it didn't work

what does 'didn't work' mean? querydef didn't open or what?