M
mma40
I created a query for last name from applicant table. The user is
asked for the last name. when entered, all records (datasheet view)
that contain that last name appear with userid, first and last name,
and DOB. The user scrolls down and when correct entry found, clicks
the record which opens the main form (with subform) for that applicant
but I would like to stay on that record but remove the filtered form.
Also on the subform, I have it sorted by Date descending but it never
comes up that way even though the form is ordered by Date Desc. Any
help would be greatly appreciated.
asked for the last name. when entered, all records (datasheet view)
that contain that last name appear with userid, first and last name,
and DOB. The user scrolls down and when correct entry found, clicks
the record which opens the main form (with subform) for that applicant
but I would like to stay on that record but remove the filtered form.
Also on the subform, I have it sorted by Date descending but it never
comes up that way even though the form is ordered by Date Desc. Any
help would be greatly appreciated.