Saving information in subform

[eacollie]

I have a subform and I want to save the username to the bound table in this subform.

I've tried creating a textbox (CompBy) and then setting the default value to = Environ("UserName") but this doesn't work.

I've tried placing the following in the afterupdate event of the subform:
Me.CompBy = Environ("username")
DoCmd.Save
But this doesn't work either.

Is there a way to do this?

Thanks!

 

[jdraw]

If you have a subform, you also have a form. How are the form and subform related?
What linkfield? What tables are bound to form and to subform?