Filter subform from button on main form
I'm trying to filter my subform based on two txtboxes and a button on the main form.
txtBeginDate and txtEndDate is the criteria I'm trying to filter the subform with but I'm having a hard time. Keep in mind that I'm not a progammer and know very little.
The fppeDate is the date in the subform that I'm trying to filter. Trying to show just the records that occured between those two dates.
Dim FilterString As String
Me.Dirty = False 'This saves any changes to make sure they appear on the QualityReviewDetails form.
FilterString = "fppeDate = Forms!MonthlyOutput!fppeDate >= me.txtBeginDate And Forms!MonthlyOutput!fppeDate <= me.txtEndDate "
Forms![FPPE]![fppeDate] = FilterString
Forms![FPPE]![fppeDate].Requery
Thanks in advance for any help!
Last edited by kawi6rr; August 11th, 2010 at 04:32 PM..
|