Hi, i am trying to open a form from selected data in an earlier from. I use cust_id = grd_customer(0, current_row).Value to hold the value so that cust_id will open up a from that has a customer's details.
But i keep on getting Unhandled Exception of type 'System.IndexOutOfRangeException' that says, there is no row at position 0. And i dont understand the problem. Can anyone explain this?
command on frm_cust_details - > lbl_cid.Text = run_sql_query("SELECT * FROM TBL_CUSTOMER WHERE CUST_IC = '" & cust_id & "'").Rows(0).Item("CUST_ID")