May 7, 2018 - I have a combo box on the main form (cbocategory) that allows the user. On using the subform's Filter property in the combo box's AfterUpdate. I am trying to filter records from a combobox, if I select Cape Town only Cape Town records must show in the subform but if I select Durban only Durban records must display in the subform. How to filter specific records using a combobox and display in a subform. Ask Question 1. Access subform not refreshing displayed records.

I am not sure if I understand you correctly, but if you want to select a line in the listbox, edit the respective record in the underlying table and then save the record and update the listbox, you could work along those lines: The listbox should not be linked, neither should the subform. Create a procedure Sub UpdateSubform() subform![id]=listbox!changetableID] End sub In the OnLoad event of the form and in the OnChange event of the listbox call this procedure In the afterUpdate event of the subform: Private Sub Form_AfterUpdate() me.parent.requery End Sub I didn't check this out myself, because I am away from my access - but it should work along those lines. If thats not what you are looking for, please edit your post and at least post the information whats in the listbox and where your subform should link to. Principles of genetics by gardner pdf converter.