var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DLookup Syntax issue
Just having a DLookup issue and I can't figure out why.
This query runs pefectly:
strOrig = DLookup("[RoleName]", "Role", "[RoleID] = 224")
However when I want to search for the ID in a particular field, my strOrig results in "".
strOrig = DLookup("[RoleName]", "Role", "[RoleID] = '" & RoleID.Value & "'")
Any ideas why? The RoleID is an auto increment field, but I didn't think that would make a difference.
This should help:
General: DLookup Usage Samples
You're using the string syntax instead of the numeric syntax.