What is the method for the default value I can use in the table schema for the "USER" field? I am attempting to preload the USER ID after a USER signs into the application so they do not have to add the value.

Thanks.

__________________
Mike

www.ehow.com/how_12388_define-default-value.html

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

Thank you for the link however that would appear to be for static values. My requirement would involve getting the USER ID (currently signed into the application) so it would not be a static default value and loading it into the record. I believe that there is a method that calls the USER (Current USER) but I do not know that method. That is what I believe that I need to insert in the default value for the field.

Mike

Mike,
Create a text box on your opening form. Set it's control source to
CurrentUser()

Then use the value of of your text box to update your table.

Kevin