Why form is not cleared after deleting a record from a form.

Creating and using forms
Post Reply
mpkelly1
Posts: 1
Joined: Mon Jan 14, 2019 5:58 pm

Why form is not cleared after deleting a record from a form.

Post by mpkelly1 »

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.
OpenOffice 4.1.6 on Windows 10
UnklDonald418
Volunteer
Posts: 1540
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Why form is not cleared after deleting a record from a f

Post by UnklDonald418 »

Welcome to the forum.
Base forms use the Model-View paradigm. The Model is data aware, but doesn't know how data is displayed, and the View knows how display information passsed to it, but it not data aware. If they lose synchronization you might see odd things. To force them to synchronize try adding a Push Button to your form and set the Action property to Refresh form.
If that doesn't solve the problem please upload a sample database with your misbehaving form.
[Forum] How to attach a document here
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Post Reply