I'm working on an orderform with order-rows bound in a DataGridView. My first Column contains ProductNo. If the User fills out the ProductNo, Columns with description, price etc are automatically filled out. These I'd like the user to be able to skip if they've filled out the first column correctly. Under what Event can I do this? The datatable lookup is done under CellValueChanged. It seems wherever I put my code it is overridden by the DGVs own procedures.
If I put a button on the form and press it, my attached code works like a charm.
dgvOrderRow.CurrentCell = dgvOrderRow.Rows(0).Cells("txtQuantity")