EVAL Function is putting out an odd result. 2

[Johnnycat1]

I have a form wherein I use the following language:

Forms!FrmProjectPricing!FrmProjectPricingFixturesSubform.Form![Unit Cost]
= Eval("IIf([Forms]![FrmProjectPricing]![FrmProjectPricingFixturesSubform]![PPFixtureLotPriceName] Is not Null,[Forms]![FrmProjectPricing]![FrmProjectPricingFixturesSubform]![PPFixtureUnitCost]=0")

The strange thing is that it is putting out a boolean 0 or 1 in the [Unit Cost] rather than evaluating the iif statement and simply changing the [Unit Cost] to 0 when the iif statement is true.

Any ideas what I am missing here? As always, your help is greatly appreciated.

 

[PHV]

Why using the Eval function instead of IsNull ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya Johnnycat1 . . .
Agree with PHV. No need for EVal here.

A starting point:

[blue]   frm As Form
   
   Set frm = Forms!FrmProjectPricing!FrmProjectPricingFixturesSubform.Form
   If Not IsNull(frm!PPFixtureLotPriceName) Then frm![Unit Cost] = 0
   Set frm = Nothing[/blue]

BTW . . . [blue][Forms]![FrmProjectPricing]![FrmProjectPricingFixturesSubform]![PPFixtureUnitCost]=0[/blue] is a comparison inside the IIF and returns True/False (-1/0).

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[Johnnycat1]

Aceman & PHV as always your posts are most helpful!

I'm good Aceman. I am glad to see you are still out there helping us VB challenged people. Again, I really appreciate the help.

My database is so much better because of the help I get at Tek-Tips.