IIf Statement

[SteveO]

I have a subform with a field that is a Yes/No type
If the field is checked Yes by data entry person it means(the item for purchase is free)and I don't want the Unit price of the item to appear in the next field on the form "unit price"

I have tried under properties for this field for "after update" do this... but having no luck.

 

[Graham Mandeno]

Hi Steve

First, make sure that the name of your "Unit Price" textbox is different
from your "Unit Price" field. Then set its ControlSource to:
=IIf( [Free], "no charge", [Unit Price])

Note that the textbox will not be editable.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

I have a subform with a field that is a Yes/No type.
If the field is checked Yes by data entry person it means(the item for

purchase is free)and I don't want the Unit price of the item to appear in
the next field on the form "unit price".

I have tried under properties for this field for "after update" do this...

but having no luck.