How to update FlexGrid using data entry form?

[Mas Juliza Alias]

Hi,

I have a data entry form where user can enter details to be added into a MSFlexGrid; which is contained in another separate form. The data are supposed to be updated on a new row of the grid each time the Add button is clicked. Here is what I have so far

Private Sub cmdAdd_Click()
    Dim i As Integer
    i = 0
    If chkDisplayTable.Value = 1 Then
        frmDisplayTideGrid.Show
    Else
        frmDisplayTideGrid.Hide
    End If
    With frmDisplayTideGrid
        With .GridTide
            .TextMatrix(i, 0) = txtDate
            .TextMatrix(i, 1) = txtHour & ":" & txtMin
            .TextMatrix(i, 2) = txtTide
        End With
    End With
 
End Sub

By using this code, the entered data are always updating the first row. How to fix this?
Thank You in advance.

[Guido Geurs]

you set i = 0
and then you add to row i the data=
.TextMatrix(i, 0) = txtDate
.TextMatrix(i, 1) = txtHour & ":" & txtMin
.TextMatrix(i, 2) = txtTide
So you set the data to (0,0); (0,1) and (0,2) or = the first row.

You can APPEND the data with:

 MSFlexGrid1.AddItem txtDate & vbtab & _
                     txtHour & ":" & txtMin  & vbtab & _
                     txtTide

[Mas Juliza Alias]

Do I need to use For/Next to add new row? And where to put the APPEND code?

[Guido Geurs]

You don't need a For-Next, the .Additem adds a new row and places the data in its cells.(see attachment)
APPEND is not a command, it's just the verb = "add at the end".

[Guido Geurs]

This is a nice program but did you consider the next topics:

- ergonomics for the user:
Why a separated input box for hour and min.?
Why not one inputbox and enter the data with dot like 12.26 ?

- What if there is an error in the grid (data mistyped or a row missing!
Retype the hole grid ?

So: why not entering the data in a textbox and put it with the program in a grid once all the data is entered in text format (easy to correct, store, ...)
You can enter it like:
12 26 1.235
12 30 1.259
12 42 1.351
...
just like the auto generated data from previous project.