form to run query with combo boxes not returning expected results

[smg]

I stripped down the attached dbase to get help with form/query/combo boxes. I would expect to see Pay Date for each combination of Period From and Period To dates selected on the Form. I know I am missing something.
Example, Selecting period from 8/24/19 to Period to 10/11/19 should return:

Period From	Period To	Pay Date
8/24/2019	8/30/2019	9/6/2019
8/31/2019	9/6/2019	9/20/2019
9/7/2019	9/13/2019	9/20/2019
9/14/2019	9/20/2019	10/4/2019
9/21/2019	9/27/2019	10/4/2019
9/28/2019	10/4/2019	10/18/2019
10/5/2019	10/11/2019	10/18/2019

[June7]

First, criteria must reference combobox names, not field names - why have form bound to table when records are not even displayed

Second, think need criteria only on one field

Third, life will be a whole lot simpler if did not have spaces in naming convention.

I am able to get criteria to work with literal dates (WHERE [Period From] BETWEEN #8/24/2029# AND #10/11/2019#) but substituting with comboboxes fails because of the ID field. Remove this from combobox RowSource.

Consider this for query (need a better name) SQL:
SELECT [Time Periods].[Period From], [Time Periods].[Period To], [Time Periods].[Pay Date]
FROM [Time Periods]
WHERE ((([Time Periods].[Period From]) Between [Forms]![Time Periods Selector]![CboPeriodFrom] And [Forms]![Time Periods Selector]![CboPeriodTo]));

I never use dynamic parameterized query. I prefer VBA to build filter string and apply to form or report.