Display values on a tabular form based on values selected from a combo box

[Naqibullah]

Dear valued colleagues,
please help me, i have a query returning values from multiple tables, based on this query, i have designed a form(tabular form) which is bound to this query, i have also included a combo box, which is looked up to the same query, after update of this combo box values on the form should be filtered, i.e it should work exactly the same as a filter option in excel or access.
please help me how to do this.

 

[GinaWhipp]

Please post the code in the After_Update event of the Combo Box.

 

[Naqibullah]

Dear GinaWhipp,
thanks the problem is resolved, i found the it finally through googling.

 

[GinaWhipp]

Great! But if you would be so kind as to post your solution. Someone having the same problem could benefit from what you found.

 

[Naqibullah]

For sure,

Private Sub Combo15_AfterUpdate()
DoCmd.ApplyFilter , "GroupID='" & Me.Combo15 & "'"
End Sub

Regards