Issue 72866 - Entry form with subform displays incorr # of records
Summary: Entry form with subform displays incorr # of records
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.4
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-12-22 01:37 UTC by klaroy
Modified: 2013-02-07 22:41 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

The OO database which connects to a MS Access database (10.15 KB, application/vnd.sun.xml.base)
2007-01-17 03:55 UTC, klaroy
no flags Details
The MS Access database (91.04 KB, application/octet-stream)
2007-01-17 03:57 UTC, klaroy
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description klaroy 2006-12-22 01:37:35 UTC
Connecting to an MS Access database.
Open a form with subform for data entry. The recordsof the subform are related
to records in the main form by a common field.
The form never shows the correct number of records in the main table, and often
can't find any records beyond the first. It shows Record 1 of 1 in the record
navigation area at the bottom of the main form. When it shows record 1 of n, n
is always less than the actual number of records in the main table. Clicking on
the button to go to the last record works correctly, and the display is updated
to show the correct number of records.
Comment 1 christoph.lukasiak 2007-01-16 16:19:26 UTC
may you attach a sample database file, showing that problem

Comment 2 klaroy 2007-01-17 03:55:08 UTC
Created attachment 42209 [details]
The OO database which connects to a MS Access database
Comment 3 klaroy 2007-01-17 03:57:20 UTC
Created attachment 42210 [details]
The MS Access database
Comment 4 klaroy 2007-04-22 22:42:04 UTC
Still an issue with release 2.2
Comment 5 kpalagin 2007-04-24 11:41:23 UTC
Confirming with m209 on WinXP - at first form shows 11 records, but when you 
step to the 11th number of records jumps to 18.
Comment 6 christoph.lukasiak 2007-04-30 15:16:11 UTC
i can repro that
Comment 7 drewjensen.inbox 2007-04-30 15:52:36 UTC
This may be a good candidate for a feature enhancement, but in an of itself is
not a bug - it is as designed.

When you first open a form with a data grid, or a data view, the record
navigator displays an asterisk next to the total record count. This is to inform
you that this is not the final count of records, as the total table has not been
read yet. When this number is valid the asterisk is removed.

Comment 8 christoph.lukasiak 2007-04-30 16:08:02 UTC
clu->atjensen: you are right - very confusing :(

-> send further to the requirements team