Setting subform field default from unbound navigation form field.

[PaulA]

Greetings,

I have a subform (actually a group of them) in a navigation form. The navigation form has an unbound field that that is populated by the user name after user logs on.

I would like to have this value be the default value in a field in each of these subforms.

I tried using the =[Forms]![frmDatabaseMainNavigation]![txtUserName] in the subform field default value property and it doesn't work. I also created another unbound field in the navigation form (UserID) in case the subform field (a controlbox bound by the ID#) needed not the description but the bound ID number.

Neither has worked.

Any ideas would be appreciated.

Thanks!