Filter a form on existing entries

  • Thread starter Thread starter Tboartz
  • Start date Start date
T

Tboartz

I have a form that the load function opens a new record. I need to apply a
filter that when reviewing existing entries it is filtered off of a combo box
on either a specific term or the field is null. I have tried various schemes,
including setting the combo box to a query that is filtered out on a specific
term or is null. I cannot seem to find the solution. Any help is appreciated.
Thank you
 
I've gotten this to work finally but for some reason something is removing
the filter when i close the form and reopen it. Having it open to a new
record via a macro in the on load function, will this disable the filter?

Klatuu said:
Have you tried
WHERE [SomeField] = "specific term" OR [SomeField] IS NULL
--
Dave Hargis, Microsoft Access MVP


Tboartz said:
I have a form that the load function opens a new record. I need to apply a
filter that when reviewing existing entries it is filtered off of a combo box
on either a specific term or the field is null. I have tried various schemes,
including setting the combo box to a query that is filtered out on a specific
term or is null. I cannot seem to find the solution. Any help is appreciated.
Thank you
Click to expand...
Click to expand...
 
Yes, it will remove the filter.
--
Dave Hargis, Microsoft Access MVP


Tboartz said:
I've gotten this to work finally but for some reason something is removing
the filter when i close the form and reopen it. Having it open to a new
record via a macro in the on load function, will this disable the filter?

Klatuu said:
Have you tried
WHERE [SomeField] = "specific term" OR [SomeField] IS NULL
--
Dave Hargis, Microsoft Access MVP


Tboartz said:
I have a form that the load function opens a new record. I need to apply a
filter that when reviewing existing entries it is filtered off of a combo box
on either a specific term or the field is null. I have tried various schemes,
including setting the combo box to a query that is filtered out on a specific
term or is null. I cannot seem to find the solution. Any help is appreciated.
Thank you
Click to expand...
Click to expand...
Click to expand...
 
I see. So you must choose one or the other, or do you know another way to
have your cake and eat it too? =) thank you for your help.

Klatuu said:
Yes, it will remove the filter.
--
Dave Hargis, Microsoft Access MVP


Tboartz said:
I've gotten this to work finally but for some reason something is removing
the filter when i close the form and reopen it. Having it open to a new
record via a macro in the on load function, will this disable the filter?

Klatuu said:
Have you tried
WHERE [SomeField] = "specific term" OR [SomeField] IS NULL
--
Dave Hargis, Microsoft Access MVP


:

I have a form that the load function opens a new record. I need to apply a
filter that when reviewing existing entries it is filtered off of a combo box
on either a specific term or the field is null. I have tried various schemes,
including setting the combo box to a query that is filtered out on a specific
term or is null. I cannot seem to find the solution. Any help is appreciated.
Thank you
Click to expand...
Click to expand...
Click to expand...
 
It makes no sense to apply a filter when you create a new record. Why not
use the After Update event of your combo to set the filter?
--
Dave Hargis, Microsoft Access MVP


Tboartz said:
I see. So you must choose one or the other, or do you know another way to
have your cake and eat it too? =) thank you for your help.

Klatuu said:
Yes, it will remove the filter.
--
Dave Hargis, Microsoft Access MVP


Tboartz said:
I've gotten this to work finally but for some reason something is removing
the filter when i close the form and reopen it. Having it open to a new
record via a macro in the on load function, will this disable the filter?

:

Have you tried
WHERE [SomeField] = "specific term" OR [SomeField] IS NULL
--
Dave Hargis, Microsoft Access MVP


:

I have a form that the load function opens a new record. I need to apply a
filter that when reviewing existing entries it is filtered off of a combo box
on either a specific term or the field is null. I have tried various schemes,
including setting the combo box to a query that is filtered out on a specific
term or is null. I cannot seem to find the solution. Any help is appreciated.
Thank you
Click to expand...
Click to expand...
Click to expand...
 
My thought would be, what if there is not an actual update to the new
record, and the user wants to only review prior records by navigating back
through the applicable records? Not by reviewing a report or query of
collected data. That is truly when the filter would be applicable

Klatuu said:
It makes no sense to apply a filter when you create a new record. Why not
use the After Update event of your combo to set the filter?
--
Dave Hargis, Microsoft Access MVP


Tboartz said:
I see. So you must choose one or the other, or do you know another way to
have your cake and eat it too? =) thank you for your help.

Klatuu said:
Yes, it will remove the filter.
--
Dave Hargis, Microsoft Access MVP


:

I've gotten this to work finally but for some reason something is removing
the filter when i close the form and reopen it. Having it open to a new
record via a macro in the on load function, will this disable the filter?

:

Have you tried
WHERE [SomeField] = "specific term" OR [SomeField] IS NULL
--
Dave Hargis, Microsoft Access MVP


:

I have a form that the load function opens a new record. I need to apply a
filter that when reviewing existing entries it is filtered off of a combo box
on either a specific term or the field is null. I have tried various schemes,
including setting the combo box to a query that is filtered out on a specific
term or is null. I cannot seem to find the solution. Any help is appreciated.
Thank you
Click to expand...
Click to expand...
Click to expand...
 
Well, if you cancel the new record, you could add code to apply the filter
immediately after canceling the update.
--
Dave Hargis, Microsoft Access MVP


Tboartz said:
My thought would be, what if there is not an actual update to the new
record, and the user wants to only review prior records by navigating back
through the applicable records? Not by reviewing a report or query of
collected data. That is truly when the filter would be applicable

Klatuu said:
It makes no sense to apply a filter when you create a new record. Why not
use the After Update event of your combo to set the filter?
--
Dave Hargis, Microsoft Access MVP


Tboartz said:
I see. So you must choose one or the other, or do you know another way to
have your cake and eat it too? =) thank you for your help.

:

Yes, it will remove the filter.
--
Dave Hargis, Microsoft Access MVP


:

I've gotten this to work finally but for some reason something is removing
the filter when i close the form and reopen it. Having it open to a new
record via a macro in the on load function, will this disable the filter?

:

Have you tried
WHERE [SomeField] = "specific term" OR [SomeField] IS NULL
--
Dave Hargis, Microsoft Access MVP


:

I have a form that the load function opens a new record. I need to apply a
filter that when reviewing existing entries it is filtered off of a combo box
on either a specific term or the field is null. I have tried various schemes,
including setting the combo box to a query that is filtered out on a specific
term or is null. I cannot seem to find the solution. Any help is appreciated.
Thank you
Click to expand...
Click to expand...
Click to expand...
 
Back
Top