move to a certain record number

[snyperx3]

I have a table in my database that contains over 5000 records. Each record is displayed individually in a form that has navigation buttons at the bottom to browse them. I have a search form that you can find the certain record that you want. When I open the form back up that contains the records i want it to browse to the certan record number. I already know how to get the record number and open the form and know the place i need to put the code. Is there a line of code that would be along the lines of like form.recordset.**movetorecord#200* ? the stars surround the part that is stupid/my psuedocode. I dont want to do a loop with a record counter because that would take forever (ive already tried) Like if the record is 3000 it would start at 1 and go through each of them, and i dont want that. There is a place on the bottom in the navigation that you can type a record number and it will jump to that record. I just need this in VBA.

Thanks for any help.

Pete

 

[snyperx3]

I dont want the order of the records to be changed either, like with a requery or such.

 

[PHV]

A starting point:
DoCmd.GoToRecord , , acGoTo, 200

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Pampers]

Another to fast way to find and go to a specific record is the use of a (unbound) combobox. Maybe something to consider.

Pampers -

just back from holiday

 

[Pampers]

Hi snyperx3,

Another fast way to find and go to a specific record is the use of a (unbound) combobox. Maybe something to consider.

Pampers -

just back from holiday

 

[kimble]

Did you ever solve this problem? I have the same issue. How do you jump to a specific record?

 

[TheAceMan1]

. . . and lets not forget there's the combobox wizards 3rd option:

[blue]Find a record on my form based on the value I select in my combo box[/blue]

See Ya! . . . . . .

 

[Pampers]

So, choose to make a combobox on your toolbox, make sure the wizard-icon is selected, draw the combox on your form, and the wizard will guide you through the proces of making the combox - and choose the 3th option if it ask what type of combox it has to be...


Pampers
There is only one way to change a diaper - fast