I am creating an Access 2000 form which has a control button on it that when clicked will print a report containing the data from the form. The report is based on a querry. When the querry runs it asks the user to input a specific record # so that it can select only that record and print it in the report. I would like to add some VB code to automate the print button on my form so that when it is clicked it will be able to select the current record # from the form, pass that to the querry, and then print the report using that informaiton and without asking the user which record # to print. Any ideas. Thanks in advance.
