Recent content by newdistrict

  1. N

    Change report filters and report label caption based on form command

    No problem, and thank you for the welcome! I've been lurking around for awhile and have found this forum to be a wealth of information.
  2. N

    Change report filters and report label caption based on form command

    I was having trouble with the syntax for the WhereCondition - I'm still getting my bearings around SQL. If you have the time to show me an example of how you would setup a wherecondition for the DoCmd.OpenReport "rptProjects" with the Where conditions: [tblProjects]![Status]="Active" And...
  3. N

    Change report filters and report label caption based on form command

    Thanks, I will play around with this and see if it will work. I was hoping to avoid creating drop-down menus to select values (even if it would only be two drop downs). The users I am working with want to avoid multiple clicking, i.e. they really like having a stand-alone button for each...
  4. N

    Change report filters and report label caption based on form command

    ETA: working with MS Access 2010 I have a form, frmProjects, that has 30 command buttons. Each command button has a unique caption (e.g. Team 1 Active Projects, Team 1 Upcoming Projects, Team 2 Active Projects, Team 2 Upcoming projects, etc.). Right now, I have it set up so that each command...
See more
Top Bottom