Programmatically save a form as a query - TechRepublic
General discussion
January 28, 2000 at 11:42 AM
m.r. chambers

Programmatically save a form as a query

by m.r. chambers . Updated 25 years, 8 months ago

I 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.

This discussion is locked

All Comments