go to to specific record

[nessaguin]

Hello,
I've had a quick search but I can't seem to find any info on what I'm hoping is an easy question ...
I have a form with subforms. The main form is keyed with an auto-number field. How do I add the function to be able to jump to a certain record number in the main form - i.e. rather than having to scroll through all of the records.
Apologies if this is straitforward but I can't work it out.
ta
regards,
Mick

 

[Ninabunny]

Of course it isn't good coding practice but you could use a macro FindRecord....there is VB script as well.....

 

[rafe]

Of course there are situations where typing the record# into the record selector won't do. In those cases I use the VBA command...

DoCmd.GoToRecord ,,acGoTo ,MyRecordNumber

For if you need to go to a record in a subform I set focus to the subform first.