Populating an access table from a form for multiple records, even when parts aren't filled out again
Posted on 2006-06-22
Sorry my title isn't very good. It doesn't sum things up very well.
Currently I have the following situation:
I have a StartUp form that pops up and asks for the User name. This user name is then used to populate the "User Name" field in my main form which the user fills out. This value is then recorded in my table as user name. The problem is, upon going to the next record, the user name field on the main form will say the same user name, but it will not be recorded in the table again. I need it recorded in the table again, the same user name, until a different user signs on and a new user name is entered. Help. I am confused.