Form dislays wrong record.

[Quercus]

Good day. I have been using Access to track a collection for many years. This is a simple single table with 18 columns containing information such as date, cost, color, appearance etc. The first column is an auto number field. I have not written any code. And, since this is a one time effort, would prefer not to.
Recently I have created several small forms which when printed become labels for the collection.
I open the table, locate the record number I want to print, open the form, and enter the desired record number in the box bottom left.
My problem is that the form displays the wrong record; usually 2 or 3 below the one I want. I think I may have created the error. I am very familiar with Excel and used the same method to delete in Access. Highlight the row and hit the delete button.


How can I make the form show the correct record please? Do I need to delete the form and recreate or export the data in CSV format and re-import? Or is there a simple fix?

[June7]

The record number in the navigation bar does not necessarily correspond to the ID number in the record. It merely indicates position in the form's recordset. If the form is filtered so only 5 out of 100 records show, the ID numbers in the records might be 2, 6, 17, 44, 62 but the navigation window will still show 1, 2, 3, 4, 5. If your ID field has gaps in sequence (which is common with autonumber field), the correspondence will fail at the first gap.

Other options:

1. intrinsic search/filter tools. Right click in any data control to open the shortcut filter/sort menu, or click the tools on the ribbon

2. code (macro or VBA)

[Quercus]

Thank you. May I clarify. I am not using the auto number to find the record of interest. From the table I note record number, bottom left which might read 'Record: 500 of 900'. Then open the form and go to the similar place, bottom left where I enter "Record 500".

[June7]

Does the form show the same number of records or is there a filter applied? Also can't always rely on the sort order of records unless it is explicitly set the same in both objects.

[Quercus]

Both the table and form show the same number of records, 877. There are no filters applied, but to make sure I cleared them in the table. The table is sorted by date. I don't know how to tell the form to also sort by date. Advice please.
Martin

[June7]

The form has a Sort By property. Or base the form RecordSource on a query or an SQL statement that has sort criteria.

[Quercus]

If I add, delete or edit a record, then open a form; the form shows the wrong record. If I save, close and re-open the file, the form shows the correct record.
M

[June7]

You are attempting a procedure I've never used nor seen anyone try but I just did a quick test and it works. If you want to provide db for analysis, follow instructions at bottom of my post.

[Quercus]

dB Uploaded for examination. Filename "New Issues Zip".

[June7]

You have to attach file to post.