User Name Calc

[Bikeman17]

Here is my situation

I got a main db with 2 other dbs. Databases are set with account names and passwords. When a user logs in, I want to get his account name in a calc field with Get (Account Name) (Text) but I still get the full access account name.

Thanks for your tips

[comment]

Make sure the field is unstored.

[Bikeman17]

Indeed, thanks

[bcooney]

imho, you do not need a field for Get (AccountName). It's always available. Just grab it as needed. Show it as a merge variable on a layout.