I have a text box in a form with the following code:
Private Sub txtconverted_time_AfterUpdate()

  [converted_time] = SecToTime([total_num_sec])

End Sub

The SecToTime() function converts a Long into a time format
I get the [total_num_sec] by running a macro.

I know you shouldn't be storing calculations into a table
because it doesn't follow the rules of normalization, but
for the sake of argument that's what I'm doing.

I tested the SecToTime() function in the immediate window
and the function works.

I'm not sure why it doesn't work in the form. Any ideas?

Thanks gemann