H Humberto Registered User. Local time Today, 02:41 Joined Jan 8, 2002 Messages 40 Oct 2, 2002 #1 Hello, I'm trying to verify that we get unique data from form "A" to table "DD". the field that Im checking is "DDdate". I'm trying dlookup but I dont really know how to use it. can someone help.
Hello, I'm trying to verify that we get unique data from form "A" to table "DD". the field that Im checking is "DDdate". I'm trying dlookup but I dont really know how to use it. can someone help.
H Humberto Registered User. Local time Today, 02:41 Joined Jan 8, 2002 Messages 40 Oct 3, 2002 #2 this is what I'm using =IIf(DLookUp("[ddate]","[DD]","[ddate] = Forms![A]![dDate]"),MsgBox("Date is already in database, please enter a unique date.")) Can someone please help!!
this is what I'm using =IIf(DLookUp("[ddate]","[DD]","[ddate] = Forms![A]![dDate]"),MsgBox("Date is already in database, please enter a unique date.")) Can someone please help!!
