go to specified record vba (1 Viewer)

vsk1975

Registered User.
Local time
Today, 18:02
Joined
Mar 28, 2018
Messages
15
sir is there any vba code to display the specified record in the access form according to the id number that i entered (eg. 1 represents first record 2 for second etc..)
 

theDBguy

I’m here to help
Staff member
Local time
Today, 05:32
Joined
Oct 29, 2018
Messages
21,357
Hi. That depends. There is no inherent sort order for the data in a table. However, if you use a query, you can specify how the records should be ordered, so you can tell which record is the first and which one is the second.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 08:32
Joined
May 21, 2018
Messages
8,463
If field name is ID then and you enter that number in textbox1 then the code is

me.recordset.findfirst "ID = " & me.textbox1
 

vba_php

Forum Troll
Local time
Today, 07:32
Joined
Oct 6, 2019
Messages
2,884
vba also has a function called gotorecord which is part of the docmd object I believe. you can see it through intellisense
 

Users who are viewing this thread

Top Bottom