Form looses its record source when used as subform.

[vapid2323]

Ok I have a subform that's record source filterd with the following query:

SELECT tblSiteStaffQualificationJoin.*, tblSiteStaff.IsAuditor FROM tblSiteStaff INNER JOIN tblSiteStaffQualificationJoin ON tblSiteStaff.SiteStaffID = tblSiteStaffQualificationJoin.fk_SiteStaffID WHERE (((tblSiteStaff.IsAuditor)=True));

Basicly this subform will allow a user to select a set of auditors for a Audit.

The issue is that when I use this as a subform it seems to ignore my flag and it shows ALL the staff instead of just the auditors.

I hope that was clear, please let me know if you need more information.

Thanks

EDIT, not sure if it matters but the Subform only has one combo box, and is set as Continuous Forms

 

[vapid2323]

Well it seems this might have been my own mistake.

I was getting confused by my cbobox filter and my record sorce filters. I will post back if there is a 'REAL' issue.