Posted on 2000-05-07
Well,assume there is a employees table(emp.mdb),which contains details of all employees of a particular company.
I want to print a report containing the details of a specific employee,say with employee number 30(empno is the key field of this table) using data report.
further assume that the employee number will b supplied by the user through a text box.there is a command button(cmdprint) in the form, which accepts empno.
My doubt is how to give the sql statmnt inside the command object,so as to print the details of the desired employee?