Data Repeating Incorrectly

[user9]

I have a continuous form that displayes data from MyTable. Sometimes the data shows up correctly, though frequently all the records display whatever information was in the first record (duplicate).



Additionally, sometimes when I view the linked table it is sourced from the data displays duplicate even though it is correct.

Why does this happen, both in the table and the form?

[June7]

No idea. If you want to provide db for analysis, follow instructions at bottom of my post.

[Missinglinq]

...sometimes when I view the linked table it is sourced from the data displays duplicate even though it is correct...

I have absolutely no idea what you're saying, here!

As to

...all the records display whatever information was in the first record...

This is normal behavior when the Control in question is Unbound. An Unbound Control, one not Bound to a Field in the underlying Table or Query, will display, in all Records, the Value of the Control in the Current Record; when the Form first opens, the Current Record is the first Record, which is why you're seeing this.

Linq ;0)>

[user9]

I have absolutely no idea what you're saying, here!

As to



This is normal behavior when the Control in question is Unbound. An Unbound Control, one not Bound to a Field in the underlying Table or Query, will display, in all Records, the Value of the Control in the Current Record; when the Form first opens, the Current Record is the first Record, which is why you're seeing this.

Linq ;0)>

Thanks, Missinglinq. What I mean is, I have a continuous form where all fields are connected to valid fields in the Record Source. However, both the linked table (Record Source) and form display all records with the contents of the first record.

For example: 3 records - $ balances of $100, $200, $300, but in the table and form they show as $100, $100, $100.

[user9]

FYI june and Missinglinq, I figured it out. The linked table was set to a specific primary key. I tried re-importing the table with no primary key and the issue was resolved. For some reason, Access copied the first record into all other records for that primary key.

Thank you for the suggestions!

[Missinglinq]

Glad you got it figured out!

Good luck with your project!

Linq ;0)>