Josros, first of all you have too much clutter in your code. You have carelessly renamed the controls in the forms, but you have not taken care to rename them in the code. There are also lines of code that have incorrect syntax. In the ThisWorkbook module, you have a procedure that has the same name as one of the forms (UserForm1). Rename the procedure for example to LoadForm1. In general, do not run code that does not compile. After significant changes, always use the Debug/Compile VBAProject menu.
Please put your code in order so that at least compilation is possible, and then:
1. In the Search_Form module, in the Results1_DblClick procedure, fix the line to
.
2. In the Search_Forms module, in the Results2_DblClick procedure, change the line to
.
Artik
Bookmarks