Hi to all,
I have a form with a subform. A command button is on the main form to open a report. I select a person form the main form and the subform shows related records for that specific person. I want to print a report for records in the subform where a date field is Null. I used this line of command but it is not working.
I do not know where the error is?Code:DoCmd.OpenReport "rptMemberBorrowedBooks", view:=acViewPreview, _ WhereCondition:="[fkMemberId] = " & Me!pkMemberId & " and Forms![frmBooksBorroewdSubForm]![DueDate] is Null "
Any help is appreciated.
Sincerely yours
Khalil