You haven't entered any criteria in the dlookup though?
I did though.
I see no criteria in this expression: PLocalTime = DLookup("MyTimeZone","Settings")
Without criteria, you get the field value from the first record in the table, so you are probably correct about the table design. I see no field that you can filter on, such as UserID, to get the time shift value according to the user.
I think many here would agree with the notion that you should dispense with lookup fields in tables. Here's why http://access.mvps.org/access/lookupfields.htm
Last edited by Micron; 03-26-2017 at 12:56 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.