var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Dlookup problems
Can anyone help with this
DLookUp("[Input]","Data","[Drawing Description] = Like '*" & [Forms]![Myform]![Input] & "*'")
I'm getting a syntax error and I can't find the problem.
A couple possibilities:
1. Input is a reserved word; although access will let you get away with using it as a field name, it can cause problems in code and elsewhere.
2. The function is looking for a string, or something it can convert to a string. If the control contains a null value, it will cause an error.
Last edited by tcace; 04-18-04 at 21:49.
Two possibilities for coping with null values:
Put the control in parenthesis and add an empty string. This converts the null value into an empty string, which is a valid string value.
For example, change: [MyControl] to ([MyControl] & "")