Can I use a UserSetting field, which is a Ref field, as an Initial Value for a Ref field in another table?

[Griff]

I have created a UserSetting called ThisWorker and made it a REF field that draws on the Workers table. The intent is to give the user the ability to set themselves as a default when they enter records in my Input and Expense tables.

I’ve then set UserSetting(ThisWorker) as a Initial Value for the WorkerName in my Input table and ClaimedBy in my Expense table. Both those fields are also Ref fields drawing on the Workers table.

What I was hoping was that when I open a Form to create a new record in the Input and Expense tables, the name fields would default to ThisWorker, however it remains blank.

Not sure what I need to do to get it to work so open to suggestions.