Problem with CONTROL SOURCE

[Gilberto]

Hello,

I have a table "LevelTexts " with field "Per1". I need one textbox ("per1txt") in a report to display nothing ("") if the value of "per1"=0, and the value itself ("per1") if its >0.

Im trying the following in the textbox ("per1txt") control source but i get an #error:

=IIf(LevelTexts !Per1>0,DLookUp ("[per1]","[leveltexts]",""))

Any ideas??? Thanks,
Gilberto

[puppydogbuddy]

Hello,

I have a table "LevelTexts " with field "Per1". I need one textbox ("per1txt") in a report to display nothing ("") if the value of "per1"=0, and the value itself ("per1") if its >0.

Im trying the following in the textbox ("per1txt") control source but i get an #error:

=IIf(LevelTexts !Per1>0,DLookUp ("[per1]","[leveltexts]",""))

Any ideas??? Thanks,
Gilberto

try:
=IIf(LevelTexts !Per1>0,DLookUp ("[per1]","leveltexts") ,"")

[Gilberto]

try:
=IIf(LevelTexts !Per1>0,DLookUp ("[per1]","leveltexts") ,"")

It doesnt work, it asks me for "leveltexts ".

Thanks

[puppydogbuddy]

It doesnt work, it asks me for "leveltexts ".

Thanks

Change this:
=IIf(LevelTexts !Per1>0,DLookUp ("[per1]","leveltexts") ,"")

To:
=IIf(LevelTexts !Per1>0,DLookUp ("[per1]","LevelTexts") ,"")

[Gilberto]

Change this:
=IIf(LevelTexts !Per1>0,DLookUp ("[per1]","leveltexts") ,"")

To:
=IIf(LevelTexts !Per1>0,DLookUp ("[per1]","LevelTexts") ,"")

Thanks but no luck...again it asks for: "LevelTexts ".

[puppydogbuddy]

Thanks but no luck...again it asks for: "LevelTexts ".

Is LevelTexts the correct name of the table? Double check the spelling and case.

[Gilberto]

Is LevelTexts the correct name of the table? Double check the spelling and case.

Yes it is. I have other controls using DlookUp to get its value, the problem with THIS specific control is the IIF, which i cant get to work.

[puppydogbuddy]

Yes it is. I have other controls using DlookUp to get its value, the problem with THIS specific control is the IIF, which i cant get to work.

=IIf(LevelTexts !Per1>0,DLookUp ("[per1]","LevelTexts", "[per1]> 0"),"")