hey guys,
anything wrong with my this line of code?
Forms!frmMTKManager!subfrm
ServicingW
orkHours.F
ilter = "[CalendarDate] >= #" & Format(Me.txtServicingWork
HoursStart
Date, "m-d-yy") & "#"
gives me this error message
![1]()
i want to filter the query from a certain date to a certain date = ) thanks guys!!
ron, thanks, i knew we could use me to refer to the calling form but your bolding of the FORM word helped me spot the correct code i should use = )
thanks jeff! i always thought i had to put things in a certain format. now i know i don't need to so long as it's a real date. and yup i will bear in mind about the date format. thanks!!