So, you want to show 'only active users' in the dropdown for 'new selections', but still display inactive users if they were previously selected (for historical data)?
If so, try this Primary Investigator Combo Box Rowsource:
SELECT L.USERID, L.INVNM
FROM tblLOGIN AS L
INNER JOIN...