Search Form with Blank Feilds

[John_G]

Not sure if this will work, but open your report in design view. In properties, look for a property Filter on Load. If that is set to No, change it to Yes, and try running the report.



If that does work, then IMO, that is not one of Microsoft's more brilliant changes, as it causes a lot of DoCmd.Openreport statements not to work as they used to.

[nrypka]

Unfortunately it did not work

[nrypka]

I got it to work using some of Allen Browne's code

 
 Dim strWhere As String
    If Me.Dirty Then    'Save any edits.
        Me.Dirty = False
    End If

    If Me.NewRecord Then 'Check there is a record to print
        MsgBox "Select a record to print"
    Else
        strWhere = "[ID] = """ & Me.[ID] &"""
        DoCmd.OpenReport "MyReport", acViewPreview, , strWhere     End If

[orange]

What exactly is in strWhere?
You should get in the habit of doing a debug.print strWhere to know the value of your OpenArgs.

Show us some code.

OOOoops: Seems you posted while I was typing/thinking.
Glad you have it working. ID is not usually text.