murray83
Games Collector
- Local time
- Today, 20:16
- Joined
- Mar 31, 2017
- Messages
- 729
Hi merry internet people
i think i may have asked this before but my memory is shocking and cant find what i used it for if i did ask so here i am again
this is my dlookup code
what i want the text box to display is Been Here which is stored in the table hence why have 2 criteria one for location and another if true
i have tried True as well as a 1 as shown in the above code but each time i just get the ol #Error
all and any help much appreciated
cheers
i think i may have asked this before but my memory is shocking and cant find what i used it for if i did ask so here i am again
this is my dlookup code
Code:
=DLookUp("[BeenHereText]","[tbl_BeenHere]","[Location]='Stone_Cottage_Basement' AND [BeenHere] = '1''")
what i want the text box to display is Been Here which is stored in the table hence why have 2 criteria one for location and another if true
i have tried True as well as a 1 as shown in the above code but each time i just get the ol #Error
all and any help much appreciated
cheers