var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I would be willing to pay someone to solve the problem I have described below. Please contact me if you are interested.
The field (Event1) is coded with values
AND I want to display words
Display the value of the SkinCondition field in the Convert table, where the value of the Event1 field in the table matches the value of SkinCondition control on the active form.
Example of the Expression that doesn’t work:
=DLookUp("[SkinCondition]","[Convert]","[Event1] = Forms![SkinCondition]")
To look up Event1 in the Convert table and display the matching SkinCondition for a value into a new field called EventID
Table Design: Convert
AutoID Number - primary
Form Design: Form
What I want it to do is
Convert every occurrence of the value 01010000001 and Display Edema Face in a new field called EventID
Then I will utilize the new EventID field contents in a Report.
Alternatively, if you know the form's name (example: MyForm), you could use:
=DLookUp("[SkinCondition]","[Convert]","[Event1] = '" & Screen.ActiveForm![SkinCondition] & "'")
=DLookUp("[SkinCondition]","[Convert]","[Event1] = '" & Forms!MyForm![SkinCondition] & "'")