Set the default value property of the control on your form to Date()+1

Don,
  I'm assuming you mean that when you open a new record, that date field should always
display tomorrow's date.
  Set the field's DefaultValue to
       = Date() +1
  If that's not what you need, please provide more info...

Here are a pair of functions that will provide the information you want.  It
includes a Holiday table that has a record for each company holiday.  It does
not inlcue week end dates, only week day dates that are not working days.

You can use the Default Value property of your date control to populate the
date:

=NextWorDay(Date())

Be sure to use the parentheses with the date.

Public Function NextWorkDay(dtmSomeDay As Date)
   
   dtmSomeDay = DateAdd("d", 1, dtmSomeDay)
   Do Until IsWorkDay(dtmSomeDay)
       dtmSomeDay = DateAdd("d", 1, dtmSomeDay)
   Loop
   NextWorkDay = dtmSomeDay
End Function
******************************************
Public Function IsWorkDay(dtmSomeDay As Date) As Boolean
Dim blnWorkingDay
   blnWorkingDay = Weekday(dtmSomeDay, vbMonday) < 6
   If blnWorkingDay Then
       blnWorkingDay = IsNull(DLookup("[Holdate]", "Holidays", _
           "[Holdate] = #" & dtmSomeDay & "#"))
   End If
   IsWorkDay = blnWorkingDay
End Function