I have made a database, which i am allowing to add new rows of info, now i have 5 columns.

So i have made a button, which opens a new form, with some text boxes on. I have 5 text boxes on this new form, and i want to be able to fill them in and then press this one button, to add the poece of info from each box into a certain column in the database. But when i click my add button it will only put my first text box in and that is in the first column.

I know why it does this but not how to fix it.

my code for my add button goes:

Private Sub Command1_Click()
Unload Form2
Form1.MSFlexGrid1.Refresh
Form1.MSFlexGrid1.AddItem (Text2.Text)
End Sub

i know it is the (Text2.text) that is the problem, but what do i write as extension to that for the certain column number?

If you understood that please help, if not just ask and i will try explain again.

thankyou.