Hello All
I am printing a report (which is a label) from a form using the command button.
What I want to do is have a text box on the form, so the user can input how many labels are to be printed.
My code so far is:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "RLabelGoodsIn", acViewNormal, , ""[DeliveryID]=" & Me![DeliveryID]
Do.Cmd.Close acForm, "FGoodsIn"
I have tried (DoCmd.Printout Text50.Value) and other variations but it prints the report once and then prints the form.
Is the VBA running to quickly?
Can anybody help on this.
I am printing a report (which is a label) from a form using the command button.
What I want to do is have a text box on the form, so the user can input how many labels are to be printed.
My code so far is:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "RLabelGoodsIn", acViewNormal, , ""[DeliveryID]=" & Me![DeliveryID]
Do.Cmd.Close acForm, "FGoodsIn"
I have tried (DoCmd.Printout Text50.Value) and other variations but it prints the report once and then prints the form.
Is the VBA running to quickly?
Can anybody help on this.