Using Date in MS Access Forms to Look Up Record


I have two tables:

  1. Customer Master – which has Customer Name as a field
  2. Transaction Details – which has Purchase Date as a field

I would like to create a form in MS Access that will allow the user to select the Customer Name in a combo box and then select the Purchase Date in another combo box. The subform would then display all the purchases the customer made on that particular date.

When I add the combo box to look up the date, it is listing all of the dates in the Transaction Details table, including the duplicates, which is not what I need. I only need the dates that pertain to the Customer Name that the user has selected.

How can I go about doing this?

Please help as I am new to Access.

Thank you.