Ok, I am quite experienced with database, forms, vba etc. but have never come across this issue before.
I have a form a user opens and enters data. When the user has finished entering data the user will press a command button the will print a report. This is hard coded using VBA, so I know the report name is correct and the report opens in print preview mode no issues.
The user then presses 'Print' in the top right of the screen to print the report that has just opened.
However! Instead of the report being printed the underlying form is printed.
This only happens on the first one or two tries. Then for no understandable reason the report will print as intended following the exact same procedure that caused the problem in the first place.
Has anyone ever come across this problem before?
I have a form a user opens and enters data. When the user has finished entering data the user will press a command button the will print a report. This is hard coded using VBA, so I know the report name is correct and the report opens in print preview mode no issues.
The user then presses 'Print' in the top right of the screen to print the report that has just opened.
However! Instead of the report being printed the underlying form is printed.
This only happens on the first one or two tries. Then for no understandable reason the report will print as intended following the exact same procedure that caused the problem in the first place.
Has anyone ever come across this problem before?