I have a form that Import data from Excel file. There are two fields as Timestamp and Username. I n time stamp default value is set as Now(), so when data is imported for all the record in Timestamp field a date and time is added, somehow similar i want to enter User name also with each record. There is a login form where user enter their login and password, so this import form get User name from that form. I want that when data comes in Access it should get that user name also in field User name. I try working with default value but it's not working similar to i did for timestamp but no success. Any idea on how to make this work?