I realised my mistake upon reading over this - I do DoCmd.Close before gstrActiveUser = Me.txtUsername
DoCmd.Close
gstrActiveUser = Me.txtUsername
DUHHH, ugh no wonder it wasn't working. Anyway, maybe this can help someone else.