Page 1 of 1

[Solved] Field data shows up on every record

PostPosted: Wed Aug 08, 2018 6:14 pm
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

Re: Field data shows up on every record

PostPosted: Fri Aug 10, 2018 1:19 pm
by Nocton
We need more information about your tables, field structure and form.

Re: Field data shows up on every record

PostPosted: Fri Aug 10, 2018 8:39 pm
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

Re: Field data shows up on every record

PostPosted: Fri Aug 10, 2018 9:22 pm
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.

Re: Field data shows up on every record

PostPosted: Fri Aug 10, 2018 9:37 pm
by shadow350
Thank you Thank you !!!!!!
I spent some time checking things but wasn't sure what to look for