Populate a table based on a filtered form

J

John W. Vinson

Is there a way to populate a table based on the records selected in a
filtered form?
Click to expand...

That would almost certainly be A Very Bad Idea. Storing the same data (as that
in the form's Recordsource) redundantly in a second table would typically
serve no purpose!

What are you trying to *accomplish* by doing so (that couldn't be done by
using a Query with the form's filter property)?

John W. Vinson [MVP]
 
J

JimW

I am trying to mimic an Approach Database where the data selected in a
filtered form is used in other forms and reports.
--
Thanks in advance for your help.

Jim
 
J

JimW

Actually here is the situation:

In Approach there is a find button in the menu bar. All the forms and
reports are displayed as tabs. When you click the find buitton, the form
that is currently being displayed is blanked out and you can enter your
criteria just as in a QBF. Once you click OK the result set is used in all
the forms and reports. If you click across the tabs you see the data
selected by the last QBF.
--
Thanks in advance for your help.

Jim
 
J

John W. Vinson

Actually here is the situation:

In Approach there is a find button in the menu bar. All the forms and
reports are displayed as tabs. When you click the find buitton, the form
that is currently being displayed is blanked out and you can enter your
criteria just as in a QBF. Once you click OK the result set is used in all
the forms and reports. If you click across the tabs you see the data
selected by the last QBF.
Click to expand...

That is a VERY different question.

One approach (sorry!) to this would be to have an unbound Form in which you
enter the criteria for a search. You can then base multiple Forms and/or
Reports on a query (or queries) using the controls on this form as criteria.

In Approach, do you have multiple related tables? Typically in an Access
application, different reports and different forms would be based on different
tables - often completely different sets of data, so that a filter which
applies to one would be totally irrelevant to another (e.g. searching the
Customer name and address information, vs. searching suppliers and parts).

John W. Vinson [MVP]
 
J

JimW

Isn't there a way to just save a fiter as a query? The amount of coding to
setup a query based on the unbound form is excessive.
--
Thanks in advance for your help.

Jim
 
J

John W. Vinson

Isn't there a way to just save a fiter as a query? The amount of coding to
setup a query based on the unbound form is excessive.
Click to expand...

You can copy and paste the filter string into the WHERE clause of a new query
in the query design window - or do the same sort of thing in code. I don't see
that it would be all that much easier than a properly designed form-based
query though.

John W. Vinson [MVP]
 
J

JimW

Here is the situation:

The user clicks advanced on the filter bar - clicks filter by form - fills
in the fields - clicks filter. All I want to do is capture the filter string
and save it as a query to apply to other forms &/or reports.
--
Thanks in advance for your help.

Jim
 
Top