Hi All,

i am building a productivty database for my team, i have two control text
boxes that i am having problems with, the first is called "Time Started" and
the other is "Time Finished" i need to create a macro for each one so that
when clicked it will select the relevant control box and input the current
time into the box. i have created this using the macro thing on access by
doing:

GoToControl
Time Started

RunCode
now()

then i assign this to a button. however when i click the button it selects
the correct text box but doesnt input the current time?

i am using Access 2003

Anyone??

"Dave" wrote:

> Hi All,
>
> i am building a productivty database for my team, i have two control text
> boxes that i am having problems with, the first is called "Time Started" and
> the other is "Time Finished" i need to create a macro for each one so that
> when clicked it will select the relevant control box and input the current
> time into the box. i have created this using the macro thing on access by
> doing:
>
> GoToControl
> Time Started
>
> RunCode
> now()
>
> then i assign this to a button. however when i click the button it selects
> the correct text box but doesnt input the current time?
>
> i am using Access 2003