IIf syntax problem.

What is wrong with:

=IIf([txtReadyQty]>0,DSum("[ShipQty]","tblShipmentDetails","[ReadyID] = " & [Forms]![frmPlanted][subfrmReady].Form![txtReadyID]),0)

--Steve
SteveL13Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
PatHartmanConnect With a Mentor Commented:
[Forms]![frmPlanted] !  [subfrmReady].Form![txtReadyID]
You were missing a bang.
0
All Courses

From novice to tech pro — start learning today.