ADO Recordset Movenext and Moveprevious

extor

[b][red]This message was edited by extor at 2004-9-30 12:25:12[/red][/b][hr]
[b][red]This message was edited by extor at 2004-9-30 12:19:12[/red][/b][hr]
[b][red]This message was edited by extor at 2004-9-30 10:34:12[/red][/b][hr]
I have a form that displays information based on a select query. The form is linked to a subform that displays all the record from the query. I'm try to move to the next record on the main form using the Movenext or moveprevious methods of the recordset, but the main form is NOT displaying the next record, eventhough, the recordset pointer is moving on the subform.

I want the to change to next record when I click the movenext button.
I'm using Access 2002

Any help is appreciated.

Thanks

GideonOmega

: [b][red]This message was edited by extor at 2004-9-30 12:25:12[/red][/b][hr]
: [b][red]This message was edited by extor at 2004-9-30 12:19:12[/red][/b][hr]
: [b][red]This message was edited by extor at 2004-9-30 10:34:12[/red][/b][hr]
: I have a form that displays information based on a select query. The form is linked to a subform that displays all the record from the query. I'm try to move to the next record on the main form using the Movenext or moveprevious methods of the recordset, but the main form is NOT displaying the next record, eventhough, the recordset pointer is moving on the subform.
:
: I want the to change to next record when I click the movenext button.
: I'm using Access 2002
:
: Any help is appreciated.
:
: Thanks
:
:
:
:
:
:
:

Well it depends on what you are using to access the data -- for instance if you are using an ado data control, or a data grid -- don't forget to refresh the control after you move to the next record.

ie.. adoData1.refresh

that is often the reason that you won't get the results that you expect.
[blue]
C:Dos
C:Dos Run
Run Dos Run
[/blue]