It may be caused if you have multiple printers online. Ive seen it happen where a new printer is installed. Possibly under File-Pagesetup you could change the printer from Default printer to use a specific printer.
In the code make sure you refer to a field in a subform the correct way.
You may need to make the following changes
str = Forms!MainForm!Subform.Form!Combo1
Forms!MainForm!Subform.Form!Combo2.RowSource = sqlstr
Alternatively, you could have in the criteria of combo2s rowsource...
I need to enable the user to compact the "backend" on demand. I know how to get the path of the backend using code but the problem is that it wont allow me to compact it when users have the front end open. I cant even compact it into a different name. Can anyone help?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.