I lol'd. So, naturally now that I've finished this - I need to add another query criteria. Now the form also needs to have a date selector so, if desired, the report (which as a refresher shows weekly updates for ongoing projects) will only show entries from within a chosen time span. I've got my two text boxes, short date, show calendar all set up, I just don't know how to criteria-ize this within my query. The field it should filter is from "Date entered" in the "Weekly Status Call" table already in the query. I've tried a few ways but I don't know how to properly syntax it.
Something like:
[Forms]![NameOfForm]![Text19, 17]
I just don't know how to code it right. The two text boxes are Text19 and Text17.
Text17 is date from, and Text19 is date to.
Thanks again lol