acDialog

[ShostyFan]

I have a report, on it a button and this code.

DoCmd.OpenForm "Frm_PrintTo", acNormal, WindowMode:=acDialog
MsgBox "User input was: " & Forms!Frm_PrintTo!PrinterName

The form "Frm_printTo" opens just fine, the user then selects a printer, the printer name is set to the txtBox named "PrinterName", I then save and close the Frm_PrintTo form.
This works.

But the main form crashes on the MsgBox line.

Seems like the main form can't get the PrinterName data since the PrintTo form is closed, but I thought that this is how it worked?
What am I missing?


Thanks.

[pbaldy]

No, you can't get a value from a form that's closed. The type of thing you're doing would typically done by hiding the PrintTo form in it's code. Once it's hidden the code in this form will continue, so you can get the value from it and then close it.

[ShostyFan]

How do I hide the PrintTo form? I have made the visibility false but my code does not continue. is hiding different then visibility?

[pbaldy]

That's correct. You're doing it from within the dialog form? Basically you hide it rather than close it.

[ShostyFan]

Got it, things are working correctly. Thanks!

[pbaldy]

Happy to help!