Copy from one field to another

  • Thread starter Thread starter chrisb
  • Start date Start date
C

chrisb

Hello to everyone on the board - I'm new!

I'm having a bit of a problem with Access 2000 and hope somebody can
provide an answer. I'm trying to configure a macro that when I click a
button in my form will copy today's date into a field called 'Out'.

If anyone knows how this can be done I will be very grateful.
Chris.
 
Welcome Chris,

I am going to give you a VBA solution instead of a macro. In
the properties of your button go to the Events tab and click
on the grey bar to the right of the entry line for OnClick
and you should get little builder button. Click on that and
you will get a popup form with three choices. Choose 'Code'
and you will jump to a VBA code module for the form. Now
enter...

Me!Out = Date()

.... and then close the window. You are now all done.

Cheers,

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
chrisb said:
Hello to everyone on the board - I'm new!

I'm having a bit of a problem with Access 2000 and hope somebody can
provide an answer. I'm trying to configure a macro that when I click a
button in my form will copy today's date into a field called 'Out'.

If anyone knows how this can be done I will be very grateful.
Click to expand...
 
Wow... and there I was thinking that this was going to be some sort of
long winded solution! Thank you.
 
Back
Top