I have a datagrid that contains records
I have been trying to use firstrow property by but always run into "Invalid bookmark"
What i want to do is:
1) Having a text box to accept input string
2) Search the datagrid recordset and highlight all
possible matched records from the input string (use instr() function)
3) Gather these highlighted records and move them up to the top of the datagrid so that user does not need 2 scroll all the way down to find highlighted records
Would any one advice me how can datagrid be done as the steps above?
I have been trying to use firstrow property by but always run into "Invalid bookmark"
What i want to do is:
1) Having a text box to accept input string
2) Search the datagrid recordset and highlight all
possible matched records from the input string (use instr() function)
3) Gather these highlighted records and move them up to the top of the datagrid so that user does not need 2 scroll all the way down to find highlighted records
Would any one advice me how can datagrid be done as the steps above?