Zydeceltico
Registered User.
- Local time
- Yesterday, 23:29
- Joined
- Dec 5, 2017
- Messages
- 843
In this DLookup
'JDRAW change the constraint/where to use string - quotes on CoilNumber
' This does not error now.
txtCoilNumber_PK = DLookup("CoilNumber_PK", "tblCoils", "[CoilNumber] = '" & Me.txtCoilNumber & "'") 'this line errors 2471not any more
I hope this resolves Issue #1, and you have #2 working ---so all seems ok at the moment.
JDraw - That did the trick! Thanks!
I need to study DLOOKUP some more because I was confused about the final argument. (i.e., & Me.txtCoilNumber &...)
I will look at OPTION EXPLICIT and try to wrap my mind around it.