For auto save problem
i think u can solve this problem if remove the recordsource of the form and also making the fields unbound.
And then on Save command button open a recordset to the table and save the record.
but have to write some code.
may this help u
bye.
Something better for First and Last Day of Month
for first day of month:
txtFirstDay = DateSerial(Year(txtDate), Month(txtDate), 1)
and for last day of month:
txtLastDay = DateSerial(Year(txtDate), Month(txtDate) + 1, 0)
Proper format of date
Use proper format of date.
as i had use the following code of line in my program:
Me.txtToDate = GetMonthDays(Month(Me.txtFromDate)) & "-" & _
Month(Me.txtFromDate) & "-" & _
Year(Me.txtFromDate)
and it diplays date like...