I have imported a excel 2007 file into Access 2007. The excel file 3 columns - Vendor Name, Account Name and Remarks.
I want to prepare a search form in Access 2007 with two controls on it.
[a] testbox for the user to enter the Vendor name
[b] a search command button for the user to click after he enters the Vendor name in the textbox.
ON clicking the search button, he should be displayed the corresponding Account Name and Remarks in the same form or window
Can anyone help me with this code.
Please help else I will loose my job.
