Trying to copy a row from one table into another table

Hi

Can someone help please before I go crazy.

I am a frustrated beginner, who has spent the last two days trying to copy a row selected from one table in a sheet to another table in a second sheet.
I have tried many different examples obtained from the internet, but nothing seems to work for me.
from a form I am trying to select organisation's matching a form text field and copy the matching search results into another table, which I clear down before the search process.
The table headers and number of columns in both my tables are an exact copy of each other.
Sheet "Organisation" contains the table "tblOrganisation" this is used for my form field comparison on column 2 of the table.
Sheet "OrgSearch" contains the table "tblOrgSearch" which should contain all rows found in the table "tblOrganisation".
The code I am currently trying gives me the first matching row but does not include the next two matching rows that I was expecting.
Using msgbox I have tested the selection process and that is working ok! I just cannot get all the rows across to the table "tblOrgSearch"

I am sure there is a better way of coding my solution, I have tried ListObjects etc. but got nowhere.
p.s. sorry for all the comments in my code, gone a bit overboard, but it helps when you have a problem.

To use the spreadsheet, the spreadsheet opens displaying the main form "frmMain" it's on this form that I have the above problem:
I type 'ort' in the 'Search by Organisation' field and click on the 'Search' button, it should display the results in the listbox below.
To see the work sheets etc click on the 'x' cancel button and type the password 'xyz', then click on the display sheets button to get access to the worksheets and code.

I am still developing this spreadsheet so a lot of code is still missing and it is not fully tested.

I dumped my original code and replaced it with this new code. which NOW WORKS

Please Login or Register  to view this content.