I have a FORM which is based on Query with Parameter BETWEEN [ENTER START DATE] AND [ENTER END DATE]. Within this form there is an OPTION GROUP that filters records based on Group field.
The problem is that when I enter the form the Query will run with the parameter to enter the start date and end date, the same parameter will run again when I select any check box from the OPTION GROUP, so I have to enter start date and end date twice to get the records I need filtered. How can I solve this problem? Basically what I need is to execute the parameter only once I enter the form. Note that when I remove the parameter from the query option group works fine but then I won't be able to select the dates I need to view their records.
Help is much appreciated
The problem is that when I enter the form the Query will run with the parameter to enter the start date and end date, the same parameter will run again when I select any check box from the OPTION GROUP, so I have to enter start date and end date twice to get the records I need filtered. How can I solve this problem? Basically what I need is to execute the parameter only once I enter the form. Note that when I remove the parameter from the query option group works fine but then I won't be able to select the dates I need to view their records.
Help is much appreciated