Hi everyone.
I am back now with another request for help with my Update/Edit procedure.
I am using a userform(frmSearch) to search for a record in the dataset (NumbersDB) to UPDATE the record for now. The user form has a Listbox with textbox and Combobox controls on it. This part is working correctly but it is not really what I want to achieve..
I am looking for help with the following:
1) When I make a selection (Dble_Click) in the Listbox I want to highlight the correct Row on the Sheet(NumberDB) AND populate the controls DIRECTLY FROM THE Sheet(NumberDB) and NOT from the Listbox. I know you must use the Match function for this but I do not know how to do this.
2) I also want to show the selected Row number from the Sheet(NumberDB) in the txtMatchRowNo. Currently, I am showing the SNo in the Dataset and this will differ from the Row number in the Sheet as the dataset is starting on Row 6
I am including my workbook for easy reference.
Thanking you all in advance for helping me.
Bookmarks