opening a form with a null value

[grmman]

I have a form Ineed to open with a filter.
I can get it to work as long as the filter value is not null.
When the filter val is null i get all the records. I should only get the records where the status is null.
I know I am doing somethingn dumb here.

here is my code on opening the form

 Case cfreshloans
            Let strfrmname = "frm_review1"
           
            Let strfilter = "review_status = is null"
            Call DoCmd.OpenForm(strfrmname, acNormal, strfilter)
       Case ccomploans
            Let strfilter = "review_status='Completed'"
            Let strfrmname = "frm_review1"
            Call DoCmd.OpenForm(strfrmname, acNormal, , strfilter)
        Case cpending
            Let strfilter = "review_status='Pending'"
            Let strfrmname = "frm_review1"
            Call DoCmd.OpenForm(strfrmname, acNormal, , strfilter)

thanks for the help.

 

[PHV]

Replace this:
strfilter = "review_status = is null"
By this:
strfilter = "review_status Is Null"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244