ClaraBarton
Registered User.
- Local time
- Today, 07:29
- Joined
- Oct 14, 2019
- Messages
- 699
I cannot get the variable to return a value and
I can't think of anything else to try:
I can't think of anything else to try:
Code:
GOAL: AuthorID = 2065
txtID = DLookup("[IDField]", "[tblLists]", strCrit)
Returns: AuthorID
strWhere = "txtID = " & Me.lstEditList.Value
txtID = 1932
strWhere = " & txtID & " = Me.lstEditList.Value
False
strWhere = "txtID = Me.lstEditList.Value"
txtID = Me.lstEditList.Value
strWhere = " & (txtID) & = " & Me.lstEditList.Value
& (txtID) & = 2068
strWhere = """ & (txtID) & = """ & Me.lstEditList.Value
" & (txtID) & = "2068
strWhere = "(txtID) = " & Me.lstEditList.Value
(txtID) = 2068