Dlook up Access

=?Utf-8?B?SkFH?=

Guest

Posts: n/a

30th Jan 2007

I have created a form with a field name (Store). How can I create a flag that
when a store number is entered in this field it will automatically check in
another table to verify if the store is open or closed.

The other table contain two fields Store and Date.

I tried Dlookup
=DLookUp("[Date]","[Closed]","[Store] = Forms![Closed Store_FRM]![Store]")

I tried IF statement
= IIf ( [Store] = Forms![Closed Store_FRM]![Store] ,Stop!, Go!)

Had no success

« ADODB.RecordSet | Current file name in ConsolidationReference FileName »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
dlook finding NULL	Mark	Microsoft Access VBA Modules	2	10th May 2010 07:59 PM
Dlook up on continiouse form	Simon	Microsoft Access	1	30th Jul 2009 12:03 AM
Dlook & DSum in Report and groups by Report Groupings	gumby	Microsoft Access Reports	1	18th Feb 2007 01:24 PM
DLOOK UP in Query Criteria	=?Utf-8?B?UGF1bC4=?=	Microsoft Access	1	30th Jun 2005 07:04 AM
DLook Syntax Help - for Ken Snell	Dan	Microsoft Access VBA Modules	2	30th Jul 2004 12:50 AM