Event Procedure Works on Form Until It Becomes a Subform

[Sparkydog]

Hello all - my first post on the forum! I have tried searching first but since I don't really know what is causing my problem I doubt I put the correct search terms in... so:

I have an double click event procedure that works OK on a form when the form is used "stand alone" aka by itself.


But when I place this form as a subform within another, the popup event does not work and gives me this message.


And when I hit the Cancel button this is what I see.


And for reference here is the code of the event procedure.




And here is the way the query that runs the popup looks:

[ranman256]

because its no longer there. (as standalone)
the path is now like:
forms!masterform!subform!form!job

use the builder to get the path correct!

[Sparkydog]

I have/did/do use builder but the screenshot shows that it does not seem to know there is a subform option in the command line and therefore the builder does not show the field names as options. But I went ahead and just typed the path using your recommendation and it still does not work. And I have tried a few variations on the form name and it still doesn't work. Same error message as before but with the new command path.

[aytee111]

Too many form names - remove "subform"

[Gicu]

I have/did/do use builder but the screenshot shows that it does not seem to know there is a subform option in the command line and therefore the builder does not show the field names as options. But I went ahead and just typed the path using your recommendation and it still does not work. And I have tried a few variations on the form name and it still doesn't work. Same error message as before but with the new command path.

try this [Forms]![Master Form]![Backlog 7Day]![job]

Cheers,
Vlad

[Sparkydog]

Yay! It was that and I had the word "form" in the name of my subform. After fixing both items it works! Thank you very much!