Multi Control Sources

[BT24]

Hello

My question is this, is there a way to have more then one control source. Why i want to know is because i need the text box to calculate a duration and then fill a field in the table. what it does now is that it will fill the table but the number is calculated after another text box is updated. and the time will be a minus if it goes over 12 PM and i need to calculate with out the minus

Thanks for whatever help you can give

BT24

 

[Darrylles]

Hi,

Your answer is no.

Provide more detail for an answer to the rest.

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[BT24]

Thanks for the reply

this is what i am using for the calculation:

Private Sub Finish_Time_ofCallout_AfterUpdate()
Dim ElapsedTime
ElapsedTime = DateDiff("n", [Start(time)ofCallout], [Finish(time)ofCallout]) / 60
[Duration] = ElapsedTime

End Sub

But if the Time is 12pm and i want to subtract the amount of hour between 12pm and 2am then it will give me a negative number. is there another way of doing this?

thanks alot for your help

BT24