I have a table with about 50 records in it (Access 2016). When users first load into the application, I want them to be able to pull in a two values from the same record (there will be a criteria such as [LiveActivites] = True). In the past I may have used Dlookup, but in 2003, I used to get issues when several people ran this function at the same time, so I ended up creating a recordset and read the value that way.
I need to know what is the safest/fastest way to pull in these values. It doesn't need to write anything back.