This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 95%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
I have an Access form that worked a few minutes ago, but when I tried to view the form I got this error.
There is no way to step though the form to see what is causing the error.
Help!
Thanks,
MRM256
Just curious, have you tried doing a C&R?
If you are referring to the Compact and Repair? Yes, I did.
When I open the VBA editor to review the code. The code is there, but when I type ME<.> nothing happens. I am not getting any objects I placed on the form. No ComboBoxes, TextBoxes, or Buttons.
Nothing
When you type "Me," that's inside an event procedure, right?
Yes.
ME is the form I am working with.
I have had this happen to me several times in the past and the only way I have been able to fix it is recreate the form and everything on it. This is not efficient.
MRM256
That shouldn't be the only way to fix it. However, I was asking and trying to confirm that you were entering/typing Me inside an event procedure. Are you? I don't think you can just type Me anywhere in the Form's module and expect the intellisense to work. So, just wanted to make sure you were in the right place when you were expecting the intellisense to work. If you must recreate the form, we can try another method.
Where a form has become corrupted the corruption can in most cases be corrected by copying the form to the clipboard, and pasting it under a new name. If the copy functions correctly you can then delete the original form and rename the copy with the original name.
This is how I use ME in an Event procedure.
Hi. Thanks. That's correct, but that's probably not the form with the problem, correct? Can you also post a screenshot where you typed Me in the form that doesn't display the dropdown options? I'm sure you're doing it correctly, but this request would just make sure we're all on the same page and that we're not missing anything obvious. Cheers!
I opened the corrupted form. Selected it, Did Ctrl+C to copy it opened anew form in design mode and did a Ctrl+V.
No new form was created.
Here is the corrupted form screen shot with ME not working.
Thank you!
Can you try the following also?
Cheers!
To copy a form you do not open it, either in form view or design view. Select the form in the navigation pane, right click and select Copy in the shortcut menu, then right click again and select Paste. In the ensuing dialogue paste the form either under the default name Access assigns, or under a new name of your choice.
Sorry, didn't work and I received the same error.
I also have a runtime error 7960 during AutoExec macro execution. it says:
I Something is screwy.
MRM256