Recent content by ian anderson

I have figured this out to work with all my combo boxes, and filters. Private Sub cmdOpenReport_Click() DoCmd.OpenReport "materialreceiving_rpt", acViewReport, , Me.Filter End Sub Works great, however, When i use the date fields on the form, i get a query popup box asking...

Hello there, SO i have the followign VB code in my continuous form... Option Compare Database Option Explicit Private Sub cmdFilter_Click() Dim strWhere As String 'The criteria string. Dim lngLen As Long 'Length of the criteria string to append...