movelast not moving to last record : (

[case81]

hey all,

I have a confusing problem here and i would greatly appreciate any help, thanks guys

ado data controler : adodc1 with text boxes etc bound to this, i can add and update records no problem, but when i go adodc1.movelast it moves to the record precding the one i just added, i close the program and try it again, same story, i can search for records and find them, but i cannot browse to them using movenext or movelast, any ideas??

thanks in advance

 

[grtammi]

hmm....trying using the .MoveFirst before using .MoveLast when opening the recordset - you may need to populate it before attempting to make any moves in it...

Greg Tammi, ATS Alarm Supervisor

 

[Imhoteb]

Hi,

Do I get this right? You add a record and you can't move to it.
If you add a record you first have to update your recordset to add this record in the database. Then you must refresh this recordset to add this record to the ADODC. Otherwise the ADODC can't show you the added records. You must do so everytime you add a record in your database.

 

[case81]

Thanks guys, actually a lot more stupid on my part, i just changed my query and added a sort an it all worked ok, although that didnt raise its head untill record 638 c'est la vie, thanks