Q. Using the VB Data Control AddItem Method?   I`m designing a form to look like a sales invoice using bound controls(text box controls) to receive info and update my database table. Using the AddItem method, how do I transfer the invoice data to my database table?   My program seems to be transferring the first line of my invoice as a record to my database table, placing the data in the appropriate fields, then ignores the following lines. All of the text box control (columns) that make up the subsequent lines (rows) on the invoice are bound to the same fields in the database table.   A. Suppose you want to add text1.text in field ItemName in your ItemDetails Table You can use this... ItemDetails is the name of Data contor you are opening ItemDetails.Recordset.AddNew Itemdetails.REcordset.Fields("itemNAme") = text1.text Itemdetails.REcordset.update   This will update you record in table   (15-Aug-98 Yogesh) Downloads In IE right-click and select 'Save Target As...' or in Netscape right-click and select 'Save Link As...'    View Plain Text  Not Available  Not Available