Alternative to DLookup

[Mocha Float]

Hey guys,

So I have been using the DLookup function in the AfterUpdate data macro to find values in other tables with relative ease. However, it turns out that DLookup is not web compatible (using Access 2010 web) :banghead:. I don't know any other simple solution to stick values in other tables into variables for my data macros. One solution was to use Look Up A Record in another table then sticking the value into a local variable for later use, but this becomes seemingly unnecessary when I have to go through two or more tables and need multiple Look Up A Record actions. Might anyone have any simpler solutions?

Thanks in advance!

 

[Mocha Float]

I realized I could just use a SELECT statement in my Look Up A Record action to create a table with all my needed fields. :banghead: Problem solved!