Hi
I believe my question is so rudimentary that I cannot find an answer online, even after about an hour of searching. I'm writing a macro and need an IF statement to control setting a TempVar. For the life of me, I can't figure out how to get a value into this stupid thing!
Here's the basic idea:
I've split my database. There is a table for filters on the backend, for those filters everyone needs to use. I've also made a local table for filters that each user can create. To differentiate between the two, I added a binary field named "Scope" to each. BE filters are 0, FE are 1. I need to pull that scope field to determine which table should be used.
The [Screen].[ActiveControl] is passing the ID of the filter specs. Dlookup on the query used to populate the list returns "The object doesn't contain the Automation object 'qryFilters.'
What am I missing? Thanks!