'#Type' showing in form field when I set a function to be the default value (1 Viewer)

[GoodyGoody]

Hi, I have a form field which is taken form an Integer field on a table. I want to default a value into this field so have written a function which returns and integer value. However, when I set this function to be the default value of the field the form shows #Type in the field. What am I doing wrong?

Function GetSeriesRunnerNumber(intRaceEventID As Integer, intRaceRunner As Integer) As Integer
.....
End Function

Thanks
Stephen

 

[pbaldy]

What values are you passing to the function? If they are values from the record, they're probably null at the point the function runs.

 

[GoodyGoody]

The values are from other fields but I will check what's actually being passed. Thanks

 

[pbaldy]

No problem. The default value would be applied as soon as a new record is viewed, before any values had been filled in by the user. If that's the case, you might want to apply the function in the after update event of the control for the last of the required values to be input.