combo box read from filtered subform

[joe5]

hello everyone,
hope you're doing fine,



i have a main form with 2 textboxes, 1 combo box and a tabular subform (the subform is reading from table "tblClient" and showing 3 fields "customer name", "date of registration", "gender" from table "tblClient").

in the main form, the user can use the 2 textboxes to filter by date (first textbox to enter "date from" and second textbox to enter "date to") in the subform on the filed "date of registration".

my problem is with the combo box on my main form that is reading the field "customer name" from "tblClient", when my subform is filtered by date the combo box still show all the customer names. i want the combo box to show only the "customer name" that are in the subform after it is filtered.

so is there a way to make my combo box in the main form read the "customer name" from the subform not from the table?

thank you.

[June7]

The combobox RowSource would have to include date field and apply same date range criteria.

This is called cascading (or dependent) combobox. A very common topic.

[joe5]

The combobox RowSource would have to include date field and apply same date range criteria.

This is called cascading (or dependent) combobox. A very common topic.

Thanks a lot. It worked