Filter a form on existing entries

[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

 

[Klatuu]

Have you tried
WHERE [SomeField] = "specific term" OR [SomeField] IS NULL

 

[Tboartz]

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

 

[Klatuu]

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

 

[Tboartz]

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

 

[Klatuu]

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

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

 

[Tboartz]

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

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

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

 

[Klatuu]

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

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

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

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