Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011
    Posts
    14

    Unanswered: Having problems with combobox

    Hello all,

    I need a solution to what I know is a very simple problem. I have a form that users enter basic information, their name, units checked, date etc. I want to run a report based on this information. My main form is where the users enter their info via text box or combo box, which saves to a linked table. I have a "Run Report" button at the bottom. When they click the Run Report button, a subform opens up with three boxes, Staff name, Start Date, Ending Date. I want them to be able to pick their own name and a date range to run the report. I can do each individually, but am having problems generating the report based on both criteria, name and date. Again, this report is pulling from a linked table from a separate db. I can filter the names easily enough with the macro expression builder but can't seem to do the date range. Any advice? Thanks in advance.

  2. #2
    Join Date
    Apr 2011
    Posts
    14
    Does anyone know how, or is it possible, to script a date range search in the macro expression builder. I tried but keep getting an error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •