I have come across an issue that I had never encounted in prior versions of access. I have created a criteria input form for my report. When the user clicks ok, the following code is run:

DoCmd.OpenReport "reportname", acViewReport, , "[DateReceived] between #" & Me.txtBeginDate & "# and #" & Me.txtEndDate & "#"

The report opens with the correct criteria, but it opens behind the form that the criteria form is called from (in a tab) - is there a way to make sure that this report opens in front of the other tabs?

Thanks!

It sounds like the form in which the criteria are entered is opened "modally" (i.e., keep on top until closed). That's one way another form or a report would be forced to open "behind" it.