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.
Last edited by Micron; 05-21-2019 at 08:20 AM.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.