View Single Post
 
Old 11-22-2016, 10:20 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The form in post #10 doesn't include a Dropdown with a bookmark named Dropdown1, or one with either an "HR" or "001" option, so it's difficult to know exactly what you're doing. That said, the calculation field you refer to would be expressed as:
{IF{REF Dropdown1}= "HR" {REF UXOQTY1}}
as there is no multiplication required.

PS: I note that, despite my advice against it, your form contains both content controls and formfields.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote