Writing User Name to table

[RJL1]

I have a login form and after much trial and error I decided to store the user name into a table. Problem is that I cannot find a post that will guide me in the right direction. I need to get some suggestions on how to grab the user name from a combo box and write it to a table. The table is going to be local so I have it set to erase everything from it when the login form loads. This way there should only be one record on the table.

Thanks
RL

 

[randy700]

If you intend to erase everything each time, what is the purpose of writing the record to begin with?

Look at Append queries.


Randy

 

[Shirley]

create a variable and put and put ComboBox.value into that variable and append to the table.