DLookup Expression

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

DLookup Expression

Post by burrina »

I need to lookup from tbllocks lockeduserid where lck = -1

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: DLookup Expression

Post by HansV »

That would be

DLookup("lockeduserid", "tbllocks", "lck=-1")
Best wishes,
Hans

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: DLookup Expression

Post by burrina »

Thank You Hans.