I have a subform within a subform. Subform1 filters down to a specific patient. Subform2 shows all the records. I added a command button in order to make printing a record easier, but it prints all records associated with the patient, instead of the current one on the screen. This is the command button code:
Private Sub Print_Click()
On Error GoTo Err_Print_Click
Assuming you already have a form set-up that is nice to print a single record and this is where the button is, check out the rest of the arguments of the PrintOut method; you can specify the From-To print range.
But I rarely like to print forms, I would rather setup a report that may look similar to the form, and then set either the filter or the recordsource of that report to only print the record(s) in question.
Thanks, I will probably just stick to the report and remove the button. They've already asked for a bunch of other modifications, and at this point every time they have a "suggestion" I have to refrain from singing "you can't always get what you want..." LOL