Automatic time calculation

[antonisg]

I have created a form and I have a field "time". When i enter a time i want in another field to autocomplete the time i entered previously +45 minutes. for example

Enter 15:20 and the result is 16:05

[NeoPa]

I suggest the simplest solution is to have an unbound control (not field) on your form with a formula of :

=[Time]+#0:45#

[antonisg]

I want to enter the time and to be calculated automatically. how it will "read" the time I give?

[NeoPa]

If you have a control on your form called [Time] (as you appeared to indicate in your first post - albeit referring to it as a field) the the formula includes a reference to that control as [Time]. I should mention at this point that naming anything as [Time] is highly dubious in itself as it's a reserved word and they should be avoided for names, but regardless of the name, the idea should work for you.

[antonisg]

i call it departure_time because time is a reserved word. I want to have an arrival time which is plus 45 min. I tried the expression you told me but it auto corrects to 12:45:00 pm.

[NeoPa]

What expression did you use exactly?

If you used what I posted with no amendment then that is exactly what you'd expect. That was for the name as you'd posted it earlier (Remember - my mind-reading powers should never be relied upon too heavily).

[hedges98]

atonisg - It sounds like you are putting NeoPa's suggested code in the departure_time field. Don't do this, add an unbound control (textbox I assume) and enter NeoPa's code into that:

=[departure_time]+#0:45#