[Solved] Field data shows up on every record

Creating and using forms
Post Reply
shadow350
Posts: 6
Joined: Mon Jun 18, 2018 7:16 pm

[Solved] Field data shows up on every record

Post by shadow350 »

Hi

I have a form with fields from a table
some of the fields, when I type in text it goes on every record!
seems to happen with only two of the fields
not sure why how do I change this?

thank you for your help
Last edited by shadow350 on Fri Aug 10, 2018 9:40 pm, edited 1 time in total.
open office 4.1.5
MacBook Air 10.12.6
Nocton
Volunteer
Posts: 533
Joined: Fri Nov 05, 2010 10:27 am
Location: UK

Re: Field data shows up on every record

Post by Nocton »

We need more information about your tables, field structure and form.
OpenOffice 4.1.12 on Windows 10
shadow350
Posts: 6
Joined: Mon Jun 18, 2018 7:16 pm

Re: Field data shows up on every record

Post by shadow350 »

Hi I enclosed a test database I copied mine and changed the personal data
when I input data in "horse property" and "acres" that info shows up on every record which of course changes any previous info I put in
this doesn't happen with the other fields I must be missing something but I am not sure what

I have a MacBook Air Sierra 10.12.6

thank you
Attachments
test database.odb
(16.21 KiB) Downloaded 187 times
open office 4.1.5
MacBook Air 10.12.6
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Field data shows up on every record

Post by UnklDonald418 »

The problem is that the text box controls for Horse Property and Acres on your form document are not connected to any table fields.
Open Buyer Client form document in the Edit/Design mode.
Right click on the text box for Horse Property and select Control to open the Properties: Text Box dialog.
On the Data tab select the down arrow to the right of Data field and select horse property from the list of fields.
Likewise, set the Data field to acres for the Acres text box.
Exit the Design mode and test the form. It should save what you type in those text boxes in the appropriate fields in the Buyer client table.
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
shadow350
Posts: 6
Joined: Mon Jun 18, 2018 7:16 pm

Re: Field data shows up on every record

Post by shadow350 »

Thank you Thank you !!!!!!
I spent some time checking things but wasn't sure what to look for
open office 4.1.5
MacBook Air 10.12.6
Post Reply