Report page number same as Form record number

[Martin]

Hi,

I have 51 records so far. Then I add the 52nd record in the data entry
section in a form I created. When it comes to the reports instead of being on
page 52 it becomes page 22 pushing the rest of my form entries further
forward. i.e 51 goes on p.52 etc.
What can i do so that the record entry in my form is the same as the page
number in the report.

Thanks

 

[Larry Linson]

That's insufficient information for analyzing your problem. You haven't
said what data you have, how you are retrieving it, how you are sorting the
report, and such, nor what you did to force each record to a new page.
Without that detail, we can only guess...

My _guess_ would be that you have some expectations about the ordering of
records in tables / forms and in reports that are inaccurate.

Records in a relational table, by definition, are unordered... they are not
stored in the order in which they are entered... nor are they, necessarily,
retrieved in the order in which they are stored.

Records in a report are ordered independently of the order of the data in
the Report's RecordSource, but according to what is specified in the
Report's Sorting and Grouping properties.

If you want the records stored in the order they are entered, you could
include an Autonumber field (and do not specify random order), then make
certain that when you retrieve the records you use a Query sorted on that
Autonumber field. Alternatively, you could include a field with a default
value of Now(), and sort on that in the Query you use to retrieve it.

For the report, you must set Sorting and Grouping to sort on the field you
have chosen for ordering the records. In the upper-leftmost little square in
report design, click to select "Report", then right-click, and choose
Sorting and Grouping.

Larry Linson
Microsoft Access MVP