Hello, all!
What I'm trying to do is add some text to the return value of a dlookup depending on if the adjacent textbox has a value or not. This is through the Control Source of the textbox's properties.
As an example:
If Text1's value = 0.255 (this is a return of its current dlookup without trying to add anything)
and Text2's value = 0.005
Leave Text1's value as 0.255
If Text1's value = 0.255
and Text2 is empty
Make Text1's rendered value will read (0.255)
I tried something like:
=IIf([Forms]![FormInQuestion]![Text2]=Null, "(" & (DLookUp("[TableField]","PartList","PN_ID = " & [Forms]![FormInQuestion]![TextBoxWithValueToMatch])) & ")", DLookUp("[TableField]","PartList","PN_ID = " & [Forms]![FormInQuestion]![TextBoxWithValueToMatch]))
The part in bold is was my attempt at achieving this but it's not working as intended. I'm just getting/seeing the 0.255. Does this seem like it should work and my problem is elsewhere or is my syntax wrong?
I do appreciate the help!