I've got a menu/switchboard that opens 2 forms:
1. [practice_staff_coding]
2. [frmstaff_search]
Both forms contain the subform:
3. [tblnon_standard_software subform]
The record source for 1. is:
SELECT [tblpractice_staff].[upi], [tblpractice_staff].[last_name]...