This must be easy but I don't know how...

[Hassan]

Hi there!
I have such problem: I have form "frmFilteredData" based on query "qryDataFilter" where one field (date) has criteria:

Is Not Null And Between [Forms]![frmPerfPlanDialog]![beginning date] And [Forms]![frmPerfPlanDialog]![ending date]

And I have another form "frmPerfPlanDialog" with two fields for entering beginning and ending dates.

What I want is that when I open form "frmFilteredData", first opens form "frmPerfPlanDialog" where I have to enter both dates, press ok button and just then I get that "frmFilteredData" opened with data range based on what I just typed as starting and ending date. But I don't know how to make it wprk correct.

What is the right solution for that?

 

[Jack Cowley]

I would open the form 'frmPerfPlanDialog' first and allow the user to enter the dates. On that form I would put a command button that would open the form 'frmFilterData'.