Error: (File Not Open (37)) on Browse after Insert by Form

questions
, ,
24

Maybe it’s something related to path when returning from the “photo selection” window.
it’s MSSQL but who knows.

25

Apologies for opening an old thread but this problem reared it’s ugly head again in a different proc in the same app. I finally found the problem was caused by enabling {prop:wizard} on the main sheet during an insert. I noticed that the child record insert always works when updating a parent record as the wizard is not used here, but never on inserting the parent record where the wizard is used. Removing {prop:wizard} on the main sheet on insert solved the issue immediately.

You can see in the original video that the ‘New Person Involved’ window is using the wizard on insert mode.

Regards,
Trent

26

So you made the Sheet Visible … Maybe try setting the Browse ActiveInvisible On

You could also try turning off Lazy Open

27

Thanks, Carl. Looks like the Browse ActiveInvisible setting fixes the problem! Tried turning off Lazy Open but that didn’t work. Thank you for the tip!