Copy from one field to another

[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.

 

[Gary Miller]

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
________________________

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.

 

[Ken Snell]

Action: SetValue
Control Name: Forms!FormName!Out
Expression: Date()

 

[chrisb]

Wow... and there I was thinking that this was going to be some sort of
long winded solution! Thank you.