Michael,
Give the following a try. Place the following public function in a standard
module.
Public Function CalcCutOffDate(StartDate As Date) As Date
Dim CutOffDate As Date
Dim DayOfWeek As Integer
CutOffDate = DateAdd("h", 48, StartDate)
DayOfWeek = Weekday(CutOffDate)
If Weekday(CutOffDate) = 7 Then
CutOffDate = DateAdd("d", 2, CutOffDate)
ElseIf Weekday(CutOffDate) = 1 Then
CutOffDate = DateAdd("d", 1, CutOffDate)
End If
CalcCutOffDate = CutOffDate
End Function
Then call the function from the After_Update event of the dispatch date with
the following statement:
Me.txtCutoffDate = CalcCutOffDate(Me.txtStartDate)
"txtCutoffDate" is the name of the cutoff date control and the
"txtStartDate" is the dispatch date.

Signature
HTH
Mr B
> Hi,
>
[quoted text clipped - 16 lines]
> Thanks,
> Michael
michael.staschull@gmail.com - 15 Feb 2007 15:39 GMT
> Michael,
>
[quoted text clipped - 50 lines]
>
> - Show quoted text -
Hi Mr. B
I somehow cannot get the After_Update to work..... Can I send you my
sample database ???
Thanks and best regards,
Michael
Mr B - 15 Feb 2007 17:56 GMT
michael,
If you want to send me a copy of the database, I will take a look.
Send to: mrbpolknospamplease@suddenlink.net
Just remove the nospamplease.

Signature
HTH
Mr B
> > Michael,
> >
[quoted text clipped - 58 lines]
> Thanks and best regards,
> Michael