FIlter a form (2003)

Topic

New Reply

I am trying to filter a form based on Status. I want to filter based on 2 choices on the status field – null or On Hold.
The code on the form is Me.filter= “Status=’On Hold'” and that brings back the on holds. How can I bring in the nulls also?

Thanks,
Ben

Reply | Quote

Replies

— Click on the Filter By Form icon (looks like a coffee filter in front of a form)
— In the form, go to the Status field
— It should already have “On Hold”, add or Is Null….When you are finished it should read “On Hold” or Is Null

Reply | Quote

The problem is I have this as a continous form that is based on the table. I tried what you said and saved but it doesn’t save the is null when I reopen. Is there code that I could add to make it work? Thanks

Ben

Reply | Quote

The “continuous” nature of the form should not matter.

Might you post a copy of the DB with any confidential data removed?

Reply | Quote

Question – I have the form set to no adds or edits. This form is only for viewing on holds or nulls. Would the no adds or edits affect anything?

Reply | Quote

I would not think so. What is the setting for the property “Allow Filters”? I would assume that it is “Yes”.

Reply | Quote

It is set to yes.

Reply | Quote

If the form is for viewing only those records that are On Hold or the field is null, why not skip the filters and base the form on this criteria? Go to the form’s Record Source and use the wizard to set these criteria.

Reply | Quote

That works. I just made a query based on that criteria.

Ben

Reply | Quote