Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dlook up Access
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
Access.Application.Quit - opens Access again then won't close - He | Excel Programming | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
Access data -work in Excel- save in Access | Excel Programming | |||
Getting Access Error Messages when running Access through Excel | Excel Programming |