Hello,
I have a form that lists currently adds new entries and pulls up old entries for updating. I am using a combobox to search through licence numbers and pull of the information. I am running into one major problem, the combobox only goes to the first time the licence is shown on the excel spreadsheet and when search is clicked the boxes autofill with only the first time the licence shows. This is true even if I manually got down the list and click on the second time I see the licence number, it still autofills with the first entry.
I have a attached the code I am currently using and was hoping someone could suggest if I should filter the comobox or add criteria to the search function. I really need to be able to go through all the entries associated with the licence number until I find the one I need to update. Please provide the codes needed.
Thank you so much!!
Lilian