Hi guys, i need some help,
I have a main form (FrmMain) with a button to open another Form (FrmInspection)
form main has a autonumber field (TBJobID) which i want to transfer over to the Frminspection form. so that when i open the inspection form it only shows the records for that job number
So on FRMinspection - in the before update event i have the code
Noticed tonight on my database that some of the inspections on the FRMinspection Form have all been logged against the first job in the database, and not the one they should of been linked to, I can only assume that the code is not running at the right time.
Do i need to move the code to a different trigger.
I have a main form (FrmMain) with a button to open another Form (FrmInspection)
form main has a autonumber field (TBJobID) which i want to transfer over to the Frminspection form. so that when i open the inspection form it only shows the records for that job number
So on FRMinspection - in the before update event i have the code
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
On Error GoTo Handler
If Me.NewRecord Then
tbjobid = Forms!FrmMain.Job_ID
Else
Call AuditChanges("tbJobID", "EDIT", Me)
End If
End Sub
Noticed tonight on my database that some of the inspections on the FRMinspection Form have all been logged against the first job in the database, and not the one they should of been linked to, I can only assume that the code is not running at the right time.
Do i need to move the code to a different trigger.