General discussion
-
Topic
-
Programmatically save a form as a query
LockedI have a form called Searchform, and I need to be able to save this form (after a filter has been applied, because I need to print off part of the results from the filter) as a query called SearchResults. I have a report based on this query, so everytime the form is saved as a query, it must overwrite the existing query of that name.
The problem is, this database is for use by people with little or no Access skills, and I don’t want to risk giving them the opportunity to make a mistake. Isthere some way to programmatically save the form as a query and automatically save it over the existing query, all without the user having to do a thing?
That’s not very clear, but it’ll have to do.
All Comments
Viewing 3 reply threads