Update Time

[mercwonder007]

Hello Again,

I have a date/time field in a form and I want to have a control button that when I click on it it automatically updates the time to current time. I tried a requery macro and it didn't do a thing. I then tried a repainting macro and again it didn't do a thing. Any thoughts???

 

[TheAceMan1]

How are ya mercwonder007 . . . . .

I suspect it a calculated control so try [blue]Me.ReCalc[/blue]

See Ya! . . . . . .

 

[mercwonder007]

Is this a macro function or VBA... If it is VBA I have no idea how to incorporate it.

 

[TheAceMan1]

mercwonder007 . . . . .

In the properties for the comand button, events tab, put the cursor on the [blue]Click Event[/blue] line, then click the three elipses

just to the right. This is where it goes . . .

See Ya! . . . . . .

 

[mercwonder007]

once i'm there, is that the only thing I'll type in?

 

[TheAceMan1]

mercwonder007 . . . . .

Thats all I gave ya!

When its in, [blue]Alt + Q[/blue] to get back to design view.

See Ya! . . . . . .

 

[mercwonder007]

I typed it in and went back to my form... pressed the button and nothing happened. Do I have to tell it what field to update?

 

[PHV]

Replace this:
Me.Recalc
By this:
Me![name of date/time control] = Now()

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mercwonder007]

You guys are AWESOME... Thank you very much... That worked