I have a frmAddJobNo in VB6 on w2000 that has one text box (txtJobNo) and a cmdAdd button. (I have an ADO connection to my access database that uses tblJobNo in the project on another form.) I want to click on the cmdAdd button and add the text in the txtJobNo to the tblJobNo in my Access database. Can someone help me with the code for the cmdAdd_click event? Thank you very much.