Access 2007 programming

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

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.




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
open the recordset using the sql
get the data

populate the text box

what is the issue here ?