so printing a report that is based off a form.
it prints the correct form with the correct information, then after that on the same sheet of paper it will print an empty form with all the lables but no information.
I talked with a friend and he suggested the form had continuous selected as an option is the reason im getting a second empty form printed.
I cannot find this anywhere int he properties for either the report or the form it is pulling from.
another thing ive been working with is the code for this program i am editing is:
I have tried messing with the acSelection,1,1 by editing it out and seting the different values that it prints from and having got it working except for printing a third empty form.
Any ideas on how to fix this would be helpful. its not a life or death problem but its annoying that its doing this, the second form doesnt show up on print preview.
EDIT: i checked if it was continuous and it isnt, the form the report is pulling from is single in default view, and the report is print view as default view
it prints the correct form with the correct information, then after that on the same sheet of paper it will print an empty form with all the lables but no information.
I talked with a friend and he suggested the form had continuous selected as an option is the reason im getting a second empty form printed.
I cannot find this anywhere int he properties for either the report or the form it is pulling from.
another thing ive been working with is the code for this program i am editing is:
Code:
MsgBox Err.Number, vbOKOnly, "Error Number:" & Err.Number & "; Description: " & Err.Description DoCmd.SelectObject acReport, "Pass_Zone2", True DoCmd.PrintOut acSelection, 1, 1 DoCmd.SelectObject acForm, MyForm.Name, False
Any ideas on how to fix this would be helpful. its not a life or death problem but its annoying that its doing this, the second form doesnt show up on print preview.
EDIT: i checked if it was continuous and it isnt, the form the report is pulling from is single in default view, and the report is print view as default view
Comment