Roll Time field by 30 Minutes

[Jim]

Hello Everyone,

Thank you for helping. I am stuck.

My issue is as follows:

1. I have a "Medium Time" field in a form.
2. I put an "Up Arrow" button and a "Down Arrow" button
next to the field.
3. When the user hits the "Up Arrow" button, I would
like to roll the time up 1/2 hour (30 minutes), and vice
versa with the "Down Arrow" button.

I have experiemented with the following functions: (1)
DateAdd(), (2) Format(), and I have experimented
manipulating the time field 100 different ways. I also
have check the Access Web and the Knowledge Base, but I
have not been able to jump the hurdle.

Any ideas would be greatly appreciated. I also would be
open to other techniques that will improve managing a
time field.

Thx,

Jim

 

[Jim]

Ugh! I was so close!

Thank you, that worked perfect.

Jim