Open a form and filter where date is between a date range

[jjake]

Hello,

I have a form [frmPMSearch]. It has 2 unbound text boxes with date pickers.

[FromDate]
[ToDate]

It has a button. [cmdSearch]

I have another continuous form [FrmPMTasksDue] that has a field in it [DueDate].

What i am trying to acheive
The user will open the [frmPMSearch] and select 2 dates from the date pickers. a "From" date and "To" date. When the user clicks [cmdSearch] it will open [FrmPMTasksDue] and filter all results where the [DueDate] is between the 2 dates selected on the search form.

Thanks.

 

[pbaldy]

You can adapt this to use Between and your two textboxes:

http://www.baldyweb.com/wherecondition.htm

 

[jjake]

How do I adapt to allow me to put 2 requirements?

 

[pbaldy]

Try

DoCmd.OpenForm "SecondFormName", , , "FieldName Between #" & Me.ControlName & "# AND #" & Me.OtherControlName & "#"

 

[jjake]

Perfect, thanks.

 

[pbaldy]

Happy to help.