I am using A2007 with W7. I am trying to open a form that contains a subform and have the subform filtered to match a value in a combobox. The Parent is named "F_SoldSails" and subform is "F_SoldSails_Sub". (Single Format). I am using the code below that I got from another website
strFilter = "boat_type= """ & Me.BoatTypeBox.Column(1) & """"
DoCmd.OpenForm "F_SoldSails"
Forms!F_SoldSails![F_SoldSails_Sub].Form.Filter = strFilter
Forms!F_SoldSails![F_SoldSails_Sub].Form.FilterOn = True
It opens the form and filters to the selected boat, but filters the subform to just one record when there may be 25 boat_types that match strFilter. Doing something wrong or a glitch in my file? Any help much appreciated