Filter Form On Load

[Juan4412]

How can I filter a form so that when it loads, by default it only shows records where a field (called currentStatus) Is Null or InActive

Further info if needed, this form is based off a table called employeeInfo and the form is called employeeDetails

[aytee111]

When you open the form, set a Where condition:
DoCmd.OpenForm formname,,,"CurrentStatus=Null Or CurrentStatus='InActive'"

[Juan4412]

Where would this go? Is this in the VBA for the OnOpen() event?

[aytee111]

No, it is when you open the form - where is it being opened from?

[Juan4412]

From a command button on a seperate form. I use this to open it

    Dim stDocName As String
    Dim stLinkCriteria As String


    stDocName = "employeeDetails"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

[aytee111]

Add the code I used above with: stLinkCriteria="CurrentStatus.... That is your Where condition.