[mikecompsci]

i need to add records from text boxes that are on a form. i haven't programmed in VB in forever and i need some help. How do i add the text from the boxes to an existing table?

[Emmanuel]

Hi,

You have to use a database cursor linked to your Access table (Declare, Open and Close after you finished your VB instructions on the database).

Use it like an array to fill each column concerned by corresponding form fields values in indexing the name of the cursor (First column is 0, second is 1,...etc) :

NameCursor(3) = NameFormField6.text for instance

Then when all fields values you want to record have been coded like this, use add function of the cursor to add the new record to your database.