My database has a number of reports, and I've programmed it such that people can click on the last name of a patient on any of the reports, to open that patient's record on the form. However, the form is then filtered such that they cannot search for other patients, or move to other records (unless they click on the button at the bottom to ulfilter).
How do I change the code on the report, such that the command opens the form to the correct patient, but then allows the user to navigate to or search for other records, without having to manually unfilter once in the form?
Here's my current code. Thanks in advance!
Private Sub FirstName_Click()
DoCmd.OpenForm "PatientsMainForm", WhereCondition:="[PtCaseID]=" & Me!PtCaseID
End Sub
How do I change the code on the report, such that the command opens the form to the correct patient, but then allows the user to navigate to or search for other records, without having to manually unfilter once in the form?
Here's my current code. Thanks in advance!
Private Sub FirstName_Click()
DoCmd.OpenForm "PatientsMainForm", WhereCondition:="[PtCaseID]=" & Me!PtCaseID
End Sub