I've got a form called frmReport which has 2 date textboxes which are used as search critera within a query.
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
Code:
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
