Access Filtering Question

[sk1hotpepr]

I have a continuous form that I want to allow the user to choose in the header of the form a district once. when the user chooses a district, the continuous section (detail) will be made visible, allowing the user to enter multiple records for that district.

my problem is - i want to filter to only show records that match the district, if there are none, let the user create a new record anyway. I hope this makes sense. How do I accomplish the filtering for no records?

 

[Remou]

If the Record Source for the subform is made dependent on the combo, the user should be able to enter records. For example:
SELECT tblDistrict.ID, tblDistrict.Name FROM tblDistrict WHERE tblDistrict.ID=[Forms]![frmMainForm]![cboDistrict]));

The After Update event for the combo would need to include a requery for the subform.