i have a form that is used to list multiple rows(tickets) from a single database via a query. this form is used so that people can list and update multiple records by just clicking through the fields.
i am trying to use the following to write and update a different field in the database when focus is lost and am getting error getting error 2465 can't find the field '|1' referred to in your expression. the code i am using below works correctly on a different form but not on the multiple row form that is using the query for its data source.
Code:
Private Sub Summ_Convo_LostFocus()
On Error GoTo Form_BeforeUpdate_Err
[Date Modified] = Date & " " & Time()
[Update Counts] = [Update Counts] + 1
If ([Update Counts] = 1) Then
[Audit Log Time Stamps] = [Audit Log Time Stamps] & Chr(13) & Chr(10) & Date & " - " & Time() & "- Created"
Else
[Audit Log Time Stamps] = [Audit Log Time Stamps] & Chr(13) & Chr(10) & Date & " - " & Time() & "- last modified by - " & [Modified By]
End If
Form_BeforeUpdate_Exit:
Exit Sub
Form_BeforeUpdate_Err:
MsgBox Error$
Resume Form_BeforeUpdate_Exit
End Sub
the debug highlights the following when it gives the error:
Code:
[Audit Log Time Stamps] = [Audit Log Time Stamps] & Chr(13) & Chr(10) & Date & " - " & Time() & "- last modified by - " & [Modified By]
both of those fields are in the query which comes directly from the database [Record_Store].
Any help on this would be greatly appreciated.