Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

ADO Recordset Movenext and Moveprevious

extorextor Member Posts: 2
[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






Comments

  • GideonOmegaGideonOmega Member Posts: 617
    : [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]

Sign In or Register to comment.