I have a a form for engineers to input their weekly jobs. This has 2 field, the engineers name and the weekending Date. The weekend Date is a lookup from a Weekending Date Table.
The Subform has a Combo box that looks up all the jobs that the engineer has completed, which comes from a query, and uses a Dlookup to populate the subform.
I am trying to GET the Combo to display only records for that weekending on the main form, ie. Between [Forms]![Worksheet]![WeekendingDate] and [Forms]![Worksheet]![Weekending Date] -7
The Main Form is filtered to only display the current and previous weekendings. The combo on the subform seems to pull from the first weekending, but does not update when I go to the next weekending.
Where am I going wrong?