Hi
I want to Update the selected record with the UserForm.
The reason I want to retrieve the data from the worksheet is that all the columns from the worksheet are not listed in the ListBox but I would like to update the controls on the userform
The ListBox is ONLY to search for a record
The InputForm is only to add the data to the dataset.
The Edit Record, therefore, calls the Search UserForm for the Update. I will be using the same userform later to delete a record.
That is why I need the Match Function to work with the correct record that was selected.
Thanx