Access - Print button

[SantasLittleHelper]

I currently have a print button on a form but it is currently set to print all records by default. Is it possible to change the button to print only the current record by default?

 

[xenou]

I've never used the Print button on a form. I assume you have a form with continuous record display (shows multiple records on the form, not just one). I would imagine you could create a report that your button would then be able to print. Or for that matter, you could duplicate your form and have the report print the cloned form (but with single record display on the second form). Not entirely sure as I print very rarely but can it be done - almost certainly. You just have to play around with the possible solutions.

 

[welshgasman]

Yes, just use some criteria in the open report like ID = Me.ID

I use this in one of my forms. The iPreview and iDiailog are just my variables for those parameters and I process a recordset and produce a report for each ship.

    stLinkCriteria = "[Ship] = '" & Me.cboShip.Value & "'"
    
    DoCmd.OpenReport stRptName, iPreview, , stLinkCriteria, iDialog