D/SIRS
I have a main form where I get to see names of staff with [M_ID] as one of the prime key and with [job-code1].
The sub-form is linked with job-code. (linking child field as job-code to link master field to job-code1.
The code to a command button is asf:
Dim strWhere As String
strWhere = "[M_ID] = " & Me.[M_ID]
DoCmd.OpenReport "R_CABIN", acViewPreview, , strWhere
I get message asking for parameter [M_ID].
But if I open the report it shows the record for the first person in the query.
Can you pls tell me if this code will work to print the selected record from a form which has records filtered in a subform?
brgds/captgnvr