Help with Datagrid and boolean column
I have a boolen col in my database (mdb) and I wish to change a value
from true to false with a double click.
Col4 is the boolean and the row will be selected by user.
The routine below is a disaster, any thoughts.
Private Sub grdDataGrid_Click()
Dim rownow As Integer
rownow = grdDataGrid.Row
If grdDataGrid.Col = 4 Then
If grdDataGrid.Text = "NotYet" Then
'grdDataGrid.Row = rownow
Debug.Print "inside if NOTYET loop-"; "row ";
grdDataGrid.Row
grdDataGrid.Text = "Yes"
ElseIf grdDataGrid.Text = "Yes" Then
Debug.Print "elseif loop-"; "row "; grdDataGrid.Row
grdDataGrid.Text = "NotYet"
End If
End If
'grdDataGrid.Refresh
End Sub
NOTE......Correct email BELOW
*************************************
*Note: replace damorsoft with kbrock*
*************************************
