Zero and populated field on a form

  • Thread starter Thread starter Bill Davis
  • Start date Start date
B

Bill Davis

I have subform in my database that is used to enter line
items on an orderform. When a Part Nubmer is slected and
the qty is enteted the unit price is populated from the
unit price in [InvPart]table and a sub total is given for
that line. We do get better prices at time and I have a
[ActPrice] that can be entered manually. what I would
like to do is have a code that will make the [uniteprice]
0 or blank when an [actprice] is entered.
Thank in advance
 
On the AfterUpdate event of [actprice] use:

If not isnull([actprice]) then
[unitprice]=0
end if
 
Back
Top