ACCESS Code To Populate Future Date From Numerous Values

[SimpDogg]

Hey guys another Newbie here...

I have a combobox(JobName) on my form tied to a
table named (Jobs) with one field for all of the
jobs in the comboxbox. I want to auto populate the
Due Out Date on the form based off the job selection.
The only thing I could come up with is this

If [Job_Name].Value = "EZ0032" Then
   [Due_Out_Date] + 4
ElseIf [Job_Name].Value = "EZ0840" Then
   [Due_Out_Date] + 3
ElseIf [Job_Name].Value = "EZ0033" Then
   [Due_Out_Date] + 2
ElseIf [Job_Name].Value = "LS 2706" Then
   [Due_Out_Date] + 1
Else:  [Due_Out_Date] + 5
 
End If
 
End Sub

The Problem is that there are over 200 different
Job Name(Values) and we are always adding more
or changing due out dates. I don't know how to write
code to cover all of the values in the Jobs Table Field
If I was to list the Jobs in different fields based off the
due out dates...For Instance; [Jobs] field1 = 2 day jobs,
[Jobs] field2= three day jobs etc. and still get my JobName combo
box to still populate with all of the jobs together just like in
the Jobs table.


I am stomped!!!