default date button on form

K

koelaboe

hi all

on my data entry form i have a date field.
how do i setup a button, somewhere on same form, to have a window open with
the request to input the new default date for the new month?

thanks
nick
 
M

mscertified

There is a command button in the toolbar that you can drag onto the screen, a
wizard will guide you through what to do. You will need to choose 'form
operations' 'open form'. There are many other better ways to do it but you
were not very specific in your requirements. You could have a hidden date
field, that when you click the button becomes visible.

Dorian.
 
K

koelaboe

thanks dorian
for some reason my command button won't let me drag to design view of my form.
using access 2002, sp2.

better explanation:

data entry form:
fields: date, volunteer names (from lookup table), on line, direct service,
in office, bingo, etc...
input is number of hours served.
the date is always the first of the month.

need:
a button that changes the date to the new month so the next dozen or so
records will automatically have that date inserted.


nick
 
K

kt2902

The easiest way would be to have an unbound text box on your form where the
user can enter the new date.
Add something like the following code to the Current event of your form:
if isnull(me.[datefield]) then me.[datefield] = me.[unboundtextbox]
Then all the user has to do is change the date in the unbound textbox and
all new records will be updated with that value.
 
Top