Changing Time using a macro

[Waitsu]

I have a form where you enter in a time in HH:MM format and displays it in
military time.

I want to be able to add or subtract a specific number of hours from that
time and save it in a different field on the same form.

I tried using the following =DateAdd("h",-1,[fielda]) in the macro under the
set value option but I get an error.

I can get this to work if I create another field called fielda-date and set
the control source to =dateAdd("h",-1,[fielda-date]) then use the macro to
set the value of fielda to fielda-date - but that is the long way.

Is there a way to do this without having to go through the alternate process?

 

[Mr. B]

Waitsu,

You are using the correct function but it would appear that you are
attempting to use the "field name" as opposed to the "Name of the control"
that has the date you want to use in your calculation.

=DateAdd("h",-1,[NameOfControl])

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm