Limiting combo box selection

[Guest]

I have Table 1 that list active projects, table 2 that list biweekly
reporting information for each record in Table 1 and Table 3 that list the
submission dates for each project (which I am using as a combo box selection
in my form (table 2) that fills in the DateID field). So in the beginning of
the year the combo box may have 12 dates, as the project manager submits the
biweekly reporting I want to eliminate that date as a selection in the combo
box. Right now the row source for the dateID field is

SELECT DISTINCT [DateID], [DateReport] FROM tblDateSubmitted ORDER BY
[DateReport] DESC;

Which of course list all the choices in table 3. I appreciate any guidance
on this.

thanks!

 

[Guest]

Add something like:

WHERE DateReport > Date()

That should do it. Date() is today. You only want dates >= today's date I
would assume.