Forum Discussion

gregm57's avatar
gregm57
Copper Contributor
Jan 29, 2021
Solved

Print a single record report from a button on a form

Hello,  I am converting a database from Paradox to Access. I have limited Access experience. I am trying to print a single record on a report launched from a button on the form. I duplicated some co...
access
developer
  • Daniel_Pineault's avatar
    Daniel_Pineault
    Jan 30, 2021
    Try

    DoCmd.OpenReport "FLEET-MACHINE DATA SHEET", acViewPreview, , "[UNIT]=" & Me.Unit
Daniel_Pineault's avatar
Daniel_Pineault
MVP
Jan 30, 2021
Try

DoCmd.OpenReport "FLEET-MACHINE DATA SHEET", acViewPreview, , "[UNIT]=" & Me.Unit
  • gregm57's avatar
    gregm57
    Copper Contributor
    Feb 02, 2021

    Daniel_Pineault 

     

    Thanks for the coding, it works better but still requires the user to input the unit number. Is there a way to print the record selected on the form without user input?

     

     

     

    I found another issue, I have a number of machines in inventory where the stock number has a dash "-" in it. this causes the button to fail. 

     

     

     

    Thanks again for the assistance, it is very helpful for a neophyte such as myself. 

     

     

Resources