Getting Frustrated

Okay, here's my structure

Table 1 = Customer Name and profile

Table 2 = Job Record

Table 1 and 2 have a field named "Customer Name"

Table 2's Customer Name field is a lookup field back to Table 1
(so the name is always spelled the same)

Query 1 contains the fields of the Job Record table

Form 1 contains fields from Query 1, and is used to update/edit Table 2

Query 2 contains the fields of Table 2, plus a calculated field that will assign an invoice amount based on who the customer is. I'm using an IIF statement to make this determination. The statement reads IIf ( [Customer Name]="ABC", 120, 180)

The above scenario results in Error# returned as value.

Does anyone have any suggestions?