Where to incorporate the module

[dcollard23]

How do I include a module in the formula below that excludes weekends and holidays. I don't know where to put the module.

Private Sub Date_AfterUpdate()
If Me.cboTransactionType = "BOR" Then
Me.Target_Date = CVDate(Me.Date + DLookup("[SLA Standard]", "[tblTMGTrans]", "[Transaction Type] = '" & Me.cboTransactionType & "'"))
End If
End Sub

Thanks

 

[MStef]

Look at "DemoWeekendsA2000.mdb" (attachment, zip).
I suggest to put it in Date_BeforeUpdate event.
Look at tables, Form1 (vba).
Open Form1 and try.