Dim m As integer = e.Form.Controls("ComboBox1").ValueDim y As integer= Date.Today.YearDim FirstDay As Date = New Date(y,m,1) '第一天Dim LastDay As Date = New Date(y,m,Date.DaysInMonth(y,m)) '最后一天
Tables("XXX").Filter = "日期 >=#" & FirstDay & "# And 日期<=#" & LastDay & "#"