Move next

[samotek]

Is there a command in VB with which to move to the next row in the table of Access database ?
For example my table TblCrates consists of :

CrateId City

1. Berlin

I need a command in VB with which to go to the next row,
in the case the CrateId will be 2

Can somebody help me ?

 

[PHV]

Provided you're in a bound AccessForm:
DoCmd.RunCommand acCmdRecordsGoToNext

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