Microsoft Access - Delete records from input form, but they don't appear to delete from table
Posted on 2009-04-17
I have a microsoft access table called "keystoneopportunities"
I have an input form for this table called "opportunityInput"
I've added record navigation and operation buttons on the input form
when i use the "delete record" operation button that i added, it appears to work because when i use the record navigation buttons to navigate sequentially through the records, that particular record that i deleted doesn't show up anymore. In fact, the only records that i had in the "keystone opportunity" database were about 5 test records used during development, so i deleted all of these 5 records. I then went to the actual "keystoneopportunity" table to make sure everything was gone, and in fact the records are still there. I even hit "refresh all" while viewing the table. Not sure why i can still see the records. When i go back to the "opportunityinput" form and use the navigation buttons, the records appear to be gone. Can anyone help me understand what is going on?