Thank you for your response! However, if I input

?dateserial(year(date),month(date)-1,1)

Access says there's an invalid operator in my expression. If I take the
question mark away, Access automatically updates the line to:

DateSerial(Year("Date"),Month("Date")-1,1)

And my text box gives me an #Error value. I've tried taking the quotes
away, but Access keeps putting 'em back.

"Klatuu" wrote:

?dateserial(year(date),month(date)-1,1)
9/1/2009
?dateserial(year(date), month(date)+1,0)
10/31/2009
--
Dave Hargis, Microsoft Access MVP


"Amanda" wrote:

I have 2 text boxes in a form that default to two set dates. I'd like to
update the form so that txtStartDate is the first date of last month and
txtEndDate is the last date of this month. For example, if I were to pull
the form up today, I'd like txtStateDate's default to be 9/1/09 and
txtEndDate's default to be 10/31/09. If I pull it up the form in November,
txtStartDate should be 10/1/09 and txtEndDate is 11/31/09.

Both text boxes are unbound. Any suggestions?