In form mode, how can I "go to" a specific record number

M

MEOW77

In the old 2003 version, all I had to do was put the number in the record
section at the bottom and it would go to it. That no longer works on the 2007
version. Is there any way I can still find that record number I am looking
for? The person who had the database before me deleted some records so the
number at the bottom does not match the number at the top.
 
R

Richnep

In the old 2003 version, all I had to do was put the number in the record
section at the bottom and it would go to it. That no longer works on the 2007
version. Is there any way I can still find that record number I am looking
for? The person who had the database before me deleted some records so the
number at the bottom does not match the number at the top.
Click to expand...

So if you goto record 103 your saying the PK does not say 103?
 
A

Anthos

This is because the Numer at the top, is the value of the ID field.
(possibly an Autonumber)

the number at the bottom, is the record position in the total number
of records shown.

If you put in 103, it will go to the 103rd record, if you sort by name
instead of ID for example, it would go to the 103rd name.

You need to create a filter.

place a text box on your form, then put the following code on the
after update event.

Me.Filter = "[ID]=" & Me.textbox.value
Me.FilterOn = True

This will filter the form to show you the record where [ID] = the
value you put in the text box.

Hope that helps,

Let me know if you have any further questions,
Kind Regards
Anthony Moore

IT Excellence
 
Top