Saving Results of Form Filter in a New Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Goal:
I am trying to create a form that users can filter from to run specified
reports.

Background:
I created a form that shows all of the records and fields in the associated
table. I want to be able to apply a filter to that data (e.g. filter so that
everything from a specified employee is listed) and subsequently have it
automatically saved in a new table or query.

Any suggestions? Please note that I am not a VB expert...

Thanks

Peter
 
You don't need to save the data to a new table. Your report should be based
off of a query. Simply chnage that query to use the data entered in your
form to filter.

If your query has a UserID field in it, for example, then change the
criteria under that field to something like...
=Forms![YourFormName]![YourFieldName]


If your query includes a "date added field and your form asks the user to
spcify a date range, just enter criteria in your query like...
Between Forms![YourFormName]![YourDateStartFieldName] and
Forms![YourFormName]![YourDateEndFieldName]
 
Back
Top