Sort of got it going,
Well is seems that after trying various methods I have a result that is sort of OK.
using the above code I also had the create a validation list on a separate sheet, and copy all records to that sheet, I can now hide my closed records and they are still found by autocomplete and the fields then updated by the VBA code that finds the match in the extra table.
|