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.