babyg
Level: Scholar
Registered: 15-10-2003
Posts: 32
|
Fetching data From MSFlexGrid
help,
im trying to test out if i got the correct data in msflexgrid1
Private Sub MSFlexGrid1_DblClick()
Dim RSfn As ADODB.Recordset
Dim strFN As String
Set RSfn = New ADODB.Recordset
strFN = MSFlexGrid1.TextMatrix(MSFlexGrid1.Row, MSFlexGrid1.Col)
MsgBox strFN ' Just to test if i captured the content of the cell
RSfn.Open ("select firstname from employees where lastname = '" & strFN & "'"), CNfr
MsgBox RSfn!firstname ' test the recordset
End Sub |
i get the error
| Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. (runtime error 3001) |
what i want to happen is when i click on the lastname of the employee in msflexgrid a new form will open and display the data of the the said employee...
tnx.
____________________________
help... im a fish.
|
