Problems when opening

Question

I am having the following problem (this is the pop-up message):

However, I don't know how to overcome this, any suggestions?  I do not have anything set in the OnOpen Property.  The form is a list form (split form).

Answer 1

Check the On Double Click event rather than the On Open

Answer 2

Why are you looking at the OnOpen property/event?  The error message clearly states that it has an issue with the On Dbl Click event, that is the event you need to be examining.

So start there.  I'd also be ensuring my code compiles without any errors.

Feel free to post your property value or event code for us to take a closer look at.

---

Daniel Pineault, 2010-2016
Microsoft MVP Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 3

This error is often a result of inexperienced developers trying to enter VBA code directly into an event property in the properties sheet rather than into an event procedure.  If you are unfamiliar with entering code into a form's or control's event procedures, this is how it's done in form design view:

1.  Select the form or control as appropriate and open its properties sheet if it's not already open.

2.  Select the relevant event property and select the 'build' button (the one on the right with 3 dots).

3.  Select Code Builder in the dialogue and click OK.  This step won't be necessary if you've set up Access to use event procedures by default.

4.  The VBA editor window will open at the event procedure with the first and last lines already in place.  Enter or paste in the code as new lines between these.

---

Ken Sheridan, Stafford, England

Answer 4

Hi NoviceVBAUser,

please try to check ON Dbl Click Event. if you had add something here then remove it. error will be solved.

if you had created an event then make sure you had added that correctly like mentioned below.

if you had an issue to add an event and code then please follow the steps suggested by Ken Sheridan.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].