B benc Registered User. Local time Today, 00:00 Joined Dec 31, 2001 Messages 57 Mar 18, 2004 #1 I have to check to see if a value exists in a table. I wondered if a Dlookup would work but i would need it to return a true of false value. Can anyone advise me on the code. Thanks
I have to check to see if a value exists in a table. I wondered if a Dlookup would work but i would need it to return a true of false value. Can anyone advise me on the code. Thanks
dcx693 Registered User. Local time Yesterday, 19:00 Joined Apr 30, 2003 Messages 3,265 Mar 18, 2004 #2 You can use Dlookup, but DCount would probably be just a bit easier. Use it like this: IIf(DCount(field,table,criteria)>0,true value,false value)
You can use Dlookup, but DCount would probably be just a bit easier. Use it like this: IIf(DCount(field,table,criteria)>0,true value,false value)
