when I edit the text box on my form the properties show the control source to be =CurrentUser() (this shows as ADMIN in the text box - my function (from the net) shows it as mfquigle). If I set the Control Source of the text box to the table ([tblProgram]![EnteredBy]) it does save any value I enter in the text box to the table, but it does not seem to save the default value (which is what I want) to the table (my function returns "#Error"...

Thank you very much for replying to my post - unfortunatly neither suggestion worked (maybe it's my understanding of how this works). I would like this to work like the field in the same table that has a default value of =now() to get when the user made the entry. I am useing Access 2003 - I did not see any functions to get the =Environ() (but I did try this as a default value in my table, and Access said "Unknown Function"). any ideas...

I have a custom function I got from the net to get the user. This displays the computer user un an unbound text box on a form. How do I add this to a table?
I cannot pick this as a default value in the table (only custom functions here) - please point me in the right direction - I did search the web but found insufficient help - Mark