[MS_AccessPros] New record is causing a Null error for unbound text field

 

I have a unbound textbox that is populated when the following code runs:

Private Sub EndTime_AfterUpdate()
Me.txtElaspedTime = GetElapsedTime([EndTime] - [StartTime])
End Sub

I also have this statement in the load and current events:

Private Sub Form_Current()
Me.Caption = "Cheyenne River Housing Authority"

Me.txtElaspedTime = GetElapsedTime([EndTime] - [StartTime])

End Sub

Private Sub Form_Load()
If Me.NewRecord Then
Me.UnitID = Me.OpenArgs

End If
Me.txtElaspedTime = GetElapsedTime([EndTime] - [StartTime])
End Sub

THe issue arises when I move onto a new record, then issues a "Invalid use of nulls" error.

It makes since to me because the Endtime and Starttime are not populated yet in a new record but ho do I correct it?

Thank you,

Arthur Lorenzini

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 11
• New Files 12

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___