buttons again & again & again.....

[DaveB]

Please see the other "buttons" coments below by DaveB.
This is my BVA.

Option Compare Database

Private Sub Command91_Click()
Me!DateTime1stContact = now()
End Sub

Private Sub Command92_Click()
StartDateTime = Date + Time()
End Sub
Private Sub Command93_Click()
Me!CompletionDateTime = now()
End Sub

Private Sub Command95_Click()
Me!TotalTimetoBill = DateDiff("h", Me!StartDateTime, Me!
CompletionDateTime) & Format(DateDiff("n", Me!
StartDateTime, Me!CompletionDateTime) Mod 60, ":00")
End Sub

Now I get an error that says, Runtime error '2113': The
value you entered isn't valid for this field.

I put command 95 all on one line.
Do you have any ideas about what is wrong?

 

[John Vinson]

Now I get an error that says, Runtime error '2113': The
value you entered isn't valid for this field.

What's the data type of the field bound to TotalTimeToBill? The
expression above will put a Text String to it, and you'll get an error
if the field is a Number or a Date/Time.