Return to form

[cookieduster]

A question from an old newby.

I need to return to the same place on my form after printing a report, but I return to the first ID each time.

Here is the code that I am using:

DoCmd.OpenReport "Association Giro All", acPreview, "", "[AssociationID]=[Forms]![Association Enter]![AssociationID]"
DoCmd.Close acForm, "Association Label Enter"
DoCmd.PrintOut acPrintAll, , , acMedium, 1, True
DoCmd.OpenForm "Association Enter", acNormal, "", "[AssociationID]=[Screen].[ActiveForm].[AssociationID]", , acNormal
DoCmd.Close acReport, "Association Giro All"

Any help would be greatly appreciated.

 

[evanscamman]

Why do you have to close the form? Why not just hide it?

Me.Visible = False

Evan

 

[cookieduster]

Many thanks, Evan