Hi,
Please help. I have an access form which allows the user to enter some information (time period and date) into textboxes. What is entered by the user is then fed into a query to produce a view when the user clicks on a run query button on the form.
However, I would like to allow the user to save the query with its returned data as if the field conditions were hard coded rather then dynamic. This currently is not working as the results dynamically update based on what is in the forms text boxes.
Once the query is saved I would like for the user to be able to create further views with different periods and dates that are entered into the text boxes, as required and save these too without the previous views being overwritten.
Thanks in Advance!
Please help. I have an access form which allows the user to enter some information (time period and date) into textboxes. What is entered by the user is then fed into a query to produce a view when the user clicks on a run query button on the form.
However, I would like to allow the user to save the query with its returned data as if the field conditions were hard coded rather then dynamic. This currently is not working as the results dynamically update based on what is in the forms text boxes.
Once the query is saved I would like for the user to be able to create further views with different periods and dates that are entered into the text boxes, as required and save these too without the previous views being overwritten.
Thanks in Advance!