I have a form with a combo from which user selects a print option.
The event code:
For some reason I've not been able to determine, the preview does not come to the front but rather hidden behind the form containing the combo.Code:Select Case Me.cboPrtOptions.Column(0) Case 1 FilterExp = "PicID = " & Me.PicID DoCmd.OpenReport "rptBoxLabels", acViewPreview, , FilterExp Case 2 DoCmd.OpenReport "rptBoxLabels", acViewPreview, , , , "AsSelected" Case 3 DoCmd.OpenReport "rptBoxLabels", acViewPreview End Select
What am I missing?
Thanks,
Bill