I have mine set up to go to a different layout for printing so it looks like print preview.
Here is my script.
Personnel Records is my current table. The layout "Printable Personnel Records" is based on Personnel Records. The matching records relate to a specific ID assigned to every person.
I know this one is maybe not exactly like what you may need, but hopefully you can modify it into something useful for you.
Without knowing something of the design of your database file and the what your script looks like, we can only make guesses as to what you have and why it might fail.
PHIL sorry i will put the script later