Using Forms for data reporting

[mbpaul]

Hi there all I am very new at using access and it is taking me a while to figure it all out. I have created a database to track our work orders. I have a form that is identical to our work order sheet to make data entry much easier. I am wondering though if there is a way to pull up old forms. I would like to be able to click on a data line and have it pull up the form so I can print it off. It is a form that requires comments at the bottom so viewing the data on a line is difficult. alternatively is there a way to generate a report using a single line of data rather than the entire datasheet.

I am also wondering about adding pdfs or linking to the file. I am trying to set up a service history for our equipment and need a database to store our oils sample reports again i would like to be able to click on a data item and pull up the pdf

Thanks
Michael

 

[rzw0wr]

You can pull up old forms, Yes
The work orders should have an ID number that is related to the PK ( autonumber).
You can make a combo box of the Work Order numbers and open the form from the combos box.

Row Source for combo Select ID, WorkOrder FROM WorkOrderTable ORDER BY WorkOrder:

To open form,
DoCmd.OpenForm "frmWorkOrder",,,"ID=" & comboBox,AcWindowNormal

Dale

 

[mbpaul]

OK thanks for the help but I'm not totally sure I understand. I tried creating a combo box but it doesn't let me. I have found the old forms they are stored in a tab at the bottom of the form page. But is there a way to link to them directly from the data table. I thought I read somewhere that if you double click on the ID number it should pull up the form but its not working.

I also figured out the second part of my question