I have a a few forms that open into another called CAPA. Whether I use a macro or VBA for a button to open the CAPA form, it opens as a new record instead of the one I want. I have an ID that I am using for the where condition. Even if I open the from from the objects panel on the left, it opens as a new form, so I figure that the issue is with the form itself and not the buttons. I have it set to filter on load (I've tried using it on and off) and I've toggled data entry.
Any ideas?
Any ideas?