Do I use a parameter or a filter?

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

Guest

I created a parameter query from which I then created a form. It looks and
does exactly what I want except if I want to create a new record in the form,
then I need it to run the parameter again...is there a way to do this without
closing and opening the form again; or do I need to create a filter to do
this instead of the parameter?
 
Hi,


A filter will only consider the recordset already present, ready, in your
application. A parameter is useful to limit the data brought to your
application from the entire database. Applying a filter to it won't bring
any other record. A filter is like to say: from what I actually have
(limited by the parameter).

By analogy, consider the water in the ocean (the database). You bring some
water in a glass (the 'parameter' limiting the 'water' you have access to).
The filter, applied to the glass of water, is like passing the water through
a paper filter: you don't filter the whole ocean, just the water you have in
your glass.

So the parameter help to limit the data brought into your app, then any
filter will only work on that subset of data.


Force a requery to get the data modified by other users.


Hoping it may help,
Vanderghast, Access MVP
 
Thanks Michel. I have been messing with it for the past few days and just
this morning came across a help screen that suggested creating a Requery
macro to place on my form and it made it just perfect! But, now I'm dealing
with the same issue in a report. Is there a way to do this with a report?
 
Hi,


You should not have to requery while a report is being printed... doing so
the details, before the requery, would possibly not match the sum computed
at the end, after a requery, as example (and that, assuming a requery in the
middle of the report would be possible). Traditional printed report don't
have "filter" per se, they have a where clause to limit the recordset right
at the start of the report, and live with the generated report for the time
of the report. What are you trying to do with a "filter" in a report?


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top