Me! Help

[cecochardt]

I have a standard form that uses
Private Sub PROD_ID_AfterUpdate()
Me!DESCRIPTION = Me!PROD_ID.Column(2)
to fill in the description on an product and
Me!UNIT_COST = Me!PROD_ID.Column(3)
to fill in the Price.
My problem is I 4 different Price Option I have tried

If Me![Form]![Quote]![pricelist] = "GSA" Then Me!UNIT_COST = Me!PROD_ID.Column(5)
If Me![Form]![Quote!pricelist] = "GENERAL" Then Me!UNIT_COST = Me!PROD_ID.Column(3)
If Me![Form]![Quote!pricelist] = "OLD GSA" Then Me!UNIT_COST = Me!PROD_ID.Column(4)


If Me![Form]![Quote!pricelist] = "INTERNATIONAL" Then Me!UNIT_COST = Me!PROD_ID.Column(6)

But it doesn't work. I would like some advise please

[pbaldy]

Forms Refer to Form and Subform properties and controls