Command button help

1.I need help with writing the code for a commandbutton.I have a input field called document number and a button called run.The user inputs the document number and hit the run button to get the output.Document number is a field of my table along with fields like issuedate and revision dates.The output should show the issuedate and revisiondate for the corresponding document number the user inputs.

2.Can the output be got in the form of a record when the user hits the run button?If possible how can this be done in Access?


Any help with this is greatly appreciated.

How do you want to display the results of your search? Do you want the records displayed in a datasheet view or a form view? And is the form that has your input textbox and command button the same form displaying all the records? Depending on what view you want and what forms you have already developed, code can be more specifically written for your command button.

lwells