Why form is not cleared after deleting a record from a form.
Posted: Mon Jan 14, 2019 6:11 pm
I am using OpenOffice 4.1.6 on Windows 10. I have create a database and a form for data entry and viewing the data in my table. I have 12 fields. If I choose to delete one record using the form Navigation icon "Delete Record". The record is deleted however if the next record I look at does not have an entry for three of my field these fields are not wiped an persist from the deleted record. My question is how do I get the form to clear all fields once a record is deleted so the next record I look at or add does not have these leftover values in the fields. I assume all 12 of my field might actually need to be cleared. If I look at an existing record most of the 12 fields will have a value and replace the deleted records values. I have 3 fields that might have null values for most records but if I enter a value in the field and then decided to delete the record they persist. Hope I have explained this well enough if please ask questions.