How to Filter Records

Hi all, :bigyello:

how to Fileter Records in Access ??

suppose i have one form on which i have one dropDown for CustomerID and one sub form which show product,
if i select the CustomerID 1 then it should only show all product related that CustomerID = 1 not all records ... how can i do this ??/

Thanx in advance ...

Regards,

Write a SELECT query to display all records where CustomerId equals the dropdown box selection.