Form Based Query Doesn't Work When Loaded From Parent

[jontout]

I've got a form called frmReport which has 2 date textboxes which are used as search critera within a query.

WHERE (((tblClaims.RecDate) Between [Forms]![frmReport]![txtManRepStart] And [Forms]![frmReport]![txtManRepEnd])

This query works fine when I launch frmReport as a standalone form, however frmReport will be opened from a 'parent' for using the command Form_frmReport.Visible = True via a command button.
My problem is that when I open the form this way and complete the date textboxes, that the query then runs 2 input boxes to have me enter the date critera a second time before working.

Is there a reason behind this, and if so how would I ensure that the criteria is passed correctly?
I've tried changing the form properties to MODAL and POPUP but that's not made a difference, so I'm going to carry on tweaking but I'd like a bit of advice while I'm doing so.

Cheers,

Jon

 

[jontout]

Strangely, I've answered my own question

stDocName = "frmReport"
DoCmd.OpenForm stDocName, , , stLinkCriteria

seems to do the trick!