IIf Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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

SteveO said:
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
Click to expand...
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...
Click to expand...
but having no luck.
 
Back
Top