Filtering a Subform

[cwby1966]

Hi
I have a main form with a subform. The mainform has 2 textboxs Starting date and ending date. These are for the user to select a date range, and then clicka button to filter the subform to view only records that are in the date range. This DB is in Access 2007. I have tried appling filter with a saved query I have also tried the folloing code. Any ideas
Thanks

Private Sub Command111_Click()
Me!tbl_leasefllwup.Filter = "fllupdate = between me!start and me!end"
Me!tbl_leasefllwup.FilterOn = True
End Sub

[rsmccli]

Try something more like:

Me.Filter = "[fllupdate] Between #" & Me.Start & "# And #" & Me.End & "#"

Good luck with your problem,
rsmccli

[NeoPa]

Good advice, but the date values also aught to be formatted. See Literal DateTimes and Their Delimiters (#).

[cwby1966]

Good advice, but the date values also aught to be formatted. See Literal DateTimes and Their Delimiters (#).

Thanks
Works Perfect.