Form Filter not functioning correctly

[Poohbear0471]

I have a form to add new records or to correct records returned for errors. Filter On Load is set as [Status] = "Returned for Correction". When the form opens, it goes directly to a new record. In order to get to the records needing correction, I need to remove filters, then reapply it. I know it's something tiny I'm missing, but for the life of me, I can't figure it out. Suggestions from The Hive?

[mike60smart]

Hi

Try removing the VB in the On Open , GoToNew Record Event of the Form. You should then be able to navigate through all records "Returned for Correction"

[Micron]

I have a form to add new records

You might have Data Entry property set to Yes, or are opening the form in that mode by using code somewhere. Or you might have set a filter as you say, but Filter on Load is set to No. Using the same form for multiple purposes is wise, but sometimes the purposes are in conflict with each other. You have to know which properties to affect and often need to do so in code rather than relying on the property sheet.

[Poohbear0471]

Thanks folks! I had to add DoCmd.ApplyFilter to the OnLoad property and it works now.