Hello, I am fairly new to VB, and I'm working with ADO's. I have a few problems that I can't figure out.... 1.> I'm using a Access database and three tables. I use 1 ADO to retrieve all of the data from all 3 tables to fill textboxes. When I do a debug.print adomain.RecordCount right after getting the data but before fill the textboxes, the count is ALWAYS -1. But the data fills the textboxes and I can scroll through just fine. 2.> If I make changes to the data in a textbox, do I need to use an SQL statement to update the DB or can I use the ADO's update method? I've looked at alot of examples and they are using a statement like adomain!fields "textbox1" = txtTextbox1 & then an adomain.update. I've tried to use this method, but always error out. 3.> And last after scrolling through the data using the .MovePrevious method, always returns an error even though the .MoveNext method works just fine. I do have an 'if BOF' statement to check to see that it is not at the beginning of the file. I believe all of these errors are related to the fact that the RecordCount is always -1, but I can't figure out what I am doing wrong. I greatly appreciate any suggestions that anybody might have. Thanks, -Rick

Try using this syntax: Recordset.Update [Fields], [Values]

it's very helpfull & easy contents.