Hi guys,
i have a search button facility on my vb front end and Access back end. I have a reference number which you type in the search text box and the information in that table i want to retrieve and displayed in the text boxes and then save them in another table in Access.

Any code for it or if i can get some guidance will be much appreciated...

Thank you