Setting a default date with multiple criteria

[Anna]

I am an extreme newbie to Access and need help setting a default date
on a form.
The situation is:
I have a field called date_received which is set to default to today's
date.
I have another field called date_sent which must be sent to either 10,
14, 20 or 21 days after the date_received based on multiple fields
which the user selects. These field are both combo boxes and the user
must select an existing value.

I know how to build case statements in SQL but the syntax in VB is
eluding me - the pseudo code would be something like:

If process_server_code like IRS set the sent_date to 21 days after the
received_date.
If process_server_code like Child Support set the sent_date to 14 days
after the received_date.
If state = WA set the sent_date to 20 days after the received_date.
Else set sent_date to 10 days after the received date.

I know this would work in SQL because it would assign the values based
on the first one that it hit that was true - but have no idea how to
make this happen in Access.
Any help would be appreciated, thanks.

[Reggie]

Anna, Something like this(Air Code-Not tested):

Select Case Me.[process_server_code]
Case "IRS"
Me.[sent_date] = ((Me.[received_date]) + 21)
Exit Sub
Case "Child Support"
Me.[sent_date] = ((Me.[received_date]) + 14)
Exit Sub
End Select

If Me.[state] = "WA" Then
Me.[sent_date] = ((Me.[received_date]) + 20)
Exit Sub
Else
Me.[sent_date] = ((Me.[received_date]) + 10)
Exit Sub
End If

--
Reggie

----------
"Anna" <an**********@gci.net> wrote in message
news:65**************************@posting.google.c om...

I am an extreme newbie to Access and need help setting a default date
on a form.
The situation is:
I have a field called date_received which is set to default to today's
date.
I have another field called date_sent which must be sent to either 10,
14, 20 or 21 days after the date_received based on multiple fields
which the user selects. These field are both combo boxes and the user
must select an existing value.

I know how to build case statements in SQL but the syntax in VB is
eluding me - the pseudo code would be something like:

If process_server_code like IRS set the sent_date to 21 days after the
received_date.
If process_server_code like Child Support set the sent_date to 14 days
after the received_date.
If state = WA set the sent_date to 20 days after the received_date.
Else set sent_date to 10 days after the received date.

I know this would work in SQL because it would assign the values based
on the first one that it hit that was true - but have no idea how to
make this happen in Access.
Any help would be appreciated, thanks.