how do I default enter last month?

M

Morgan

Hi -

I would like a text box to auto-enter the month previous to today (whenever
the form is opened). I have been experimenting with =month([Today])-1, but
this yields the "Name?" in form view. The format of the field is mmmm yyyy.

Thank you.
 
R

Rick Brandt

Morgan said:
Hi -

I would like a text box to auto-enter the month previous to today
(whenever the form is opened). I have been experimenting with
=month([Today])-1, but this yields the "Name?" in form view. The
format of the field is mmmm yyyy.

Thank you.
Click to expand...

Set the default value property to =DateAdd("m", -1, Date())
 
Top