im using an array of textboxes [blue](which there are four textboxes in the array)[/blue], created on the form. each of these textboxes inputs are ment to populate a msflexgrid.
1. im trying to use the array so i can populate a record without having to use
Private Sub Command1_Click()
Dim Name As String, dr As Integer, tre As Integer, srt As Integer
Name = Text1(0).Text
MSFlexGrid1.TextMatrix(1, 1) = Name
dr = Text1(1).Text
MSFlexGrid1.TextMatrix(1, 2) = dr
tre = Text1(2).Text
MSFlexGrid1.TextMatrix(1, 3) = tre
srt = Text1(3).Text
MSFlexGrid1.TextMatrix(1, 4) = srt
this code works but i would like to move to the next record and then pupulate that.
2. how can i use an updown control button to move up and down the records so i can input a new record in a different row?
to explain... visualise a table
the inputs from the array of textboxes will represent a record on the table or msflexgrid [blue](the entire row)[/blue]
3. this can be down without an array of textboxes but im trying to work the code out to enter a record without having to state where each of the variables are going. (textmatrix(0, 1) etc) instead just the array. this may help me later on.
i hope im clear if im not anywhere im happy to explain.