Hi everyone, I'm sure this is simple, but I don't know how to approach it.

I have a simple data entry form "NewEntry" that makes new entries to my master table "JobList".

One of the fields is simply "Charge". This price varies depending on who the client is, and where the job is done.

In the past, when my client list was very short and I worked for the same clients over and over, I simply manually entered it.

Now, however, I've got a few new clients that are infrequent, so I'd like to have the field automatically enter my base price for me.

I'm thinking some nested "CASE" Statements, but I'm unsure how to use them with fields from the form.

For example (And I know this isn't workable code)

Select Case "Client"
Case "Exxon"
Select Case "Port"
Case "Oakland"
NewEntry,Charge.Value=500
Case "Seattle"
NewEntry.Charge.Value=600
End Select
Case "Chevron"
Select Case "Port"
Case "Oakland"
NewEntry,Charge.Value=450
Case "Seattle"
NewEntry.Charge.Value=650
End Select
Case Else
Debug.print "Client not on file"
End Select

Is this a workable method, and if so, how to I go about getting actual results?

If thats a bad way to approach it, How should I start?

Thank,
Richard