move next

[solar]

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 ?

[Allen Browne]

There's not a nice way to do this in a table.

Forms are designed to be the interface.
Create a form (datasheet view if you wish) bound to your table.
You can now do stuff such as:
RunCommand acCmdRecordsGoToNext

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"solar" <sp*******@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

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 ?

[Larry Linson]

If you are using VBA code to processing a Recordset in DAO, there is a
MoveNext method for the Recordset object that will do exactly what you want.
As Allen explained, you can't do that in datasheet view, but you can, in a
Form, using either the approach he explained or by using the Form's
RecordsetClone and Bookmarks (The way Allen described is easier, but it is
sometimes useful to know there is an alternative.)

Larry Linson
Microsoft Access MVP

"solar" <sp*******@gmail.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

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 ?