Join table data to another table by search query on VB and MSAccess

[Harold_8]

Hello. So I had to make this program that:

1. User enters a value (say, ID number) in a textbox, presses search, then the program searches for that particular item on a table and then copies all the row data where that ID number is.
2. Then pastes those copied data on another table in Access, then displays it on a datagrid

Thanks. Im new so I haven't made up code yet :(