Print specific record in subform

[Falcondeer]

Hi everybody

I am new to this forum and almost not very expert in ms access,

I have a db for my physiotherapy store where I have a main form and a subform, I have the following code for the command button to print a record in the subform:

Dim strReportName As String
Dim strCriteria As String
strReportName = "rptWA2"
strCriteria = "P_ID= " & Nz(Me!P_ID, 0)
DoCmd.OpenReport strReportName, acViewPreview, , strCriteria

The problem now if I have more than one record in the subform, it will always print the first record no matter what .

Now, how could I print specific record in the subform.

Thanks.

 

[Micron]

When there is more than one record, are you selecting the record you want first? If not, you'll get the first record.
If so, step through your code and see what strCriteria holds after that line has been executed (i.e. step to DoCmd but no further before mousing over strCriteria to see what it contains). As long as the record that is current (selected) is not a new record, what you have should work. If it is a new record, you'll have to save it first.

 

[jackd]

A record in your main form has some identifier. Also related records in your subform have an identifier that matches the identifier in your main form.
What is the other field/control that separates the 2 (or more) records in the subform??

I think you're looking for something beyond strCriteria = "P_ID= " & Nz(Me!P_ID, 0) that also identifies the subform record you want to report.
Could be newestDate; largest/smallest Amount.......????

 

[welshgasman]

Crossposted at Print specific record in subform

Also has solution.