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

Creating and using forms

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

Postby mpkelly1 » 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.
OpenOffice 4.1.6 on Windows 10
Posts: 1
Joined: Mon Jan 14, 2019 5:58 pm

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

Postby UnklDonald418 » Tue Jan 15, 2019 7:27 am

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.6 & LibreOffice - Windows 10 Professional
Posts: 1337
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Return to Forms

Who is online

Users browsing this forum: No registered users and 2 guests