IIf(IsError ... problem ...

[jacek.w.bak]

Hello,

On a form I have few txt boxes which give values for user as info

texbox1:


=DSum("[Amount]";"[tbl_Main]";"[ID]=" & [txtbox_ID])

testbox2
=IIf(IsError([textbox1])=True;"No Records";IIf(([textbox1]) Is Null;"No Records";[textbox1]))

on error in textbox1, textbox2 returns "No Records"
on Null in textbox1, textbox2 returns returns "No Records"

If I combine the two to have just one text box it doesn't work
ex:
=IIf(IsError([DSum("[Amount]";"[tbl_Main]";"[ID]=" & [txtbox_ID])])=True;"No Records";IIf((DSum("[Amount]";"[tbl_Main]";"[ID]=" & [txtbox_ID])) Is Null;"No Records";DSum("[Amount]";"[tbl_Main]";"[ID]=" & [txtbox_ID])))

any clues what is wrong?

[ssanfu]

It looks like you had a couple of extra brackets. Try this:

=IIf(IsError(DSum("[Amount]";"[tbl_Main]";"[ID]=" & [txtbox_ID]))=True;"No Records";IIf(IsNull(DSum("[Amount]";"[tbl_Main]";"[ID]=" & [txtbox_ID]));"No Records";DSum("[Amount]";"[tbl_Main]";"[ID]=" & [txtbox_ID])))