DLookup Expression
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
DLookup Expression
I need to lookup from tbllocks lockeduserid where lck = -1
-
- Administrator
- Posts: 78381
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: DLookup Expression
That would be
DLookup("lockeduserid", "tbllocks", "lck=-1")
DLookup("lockeduserid", "tbllocks", "lck=-1")
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: DLookup Expression
Thank You Hans.