>Ok Yes I see. Ok starting to make more sence now. Ok hope this is my last question. Need to make it so it sends updates with .updatenamelist and updateablefieldlist etc where in your code would I add these? With all this great help I'm going to get my database's in sql yet.

Hi Doug,

Take a look into message #841424, the example should be enough to get you started.
Note, if you are working through ADO, you need set UpdateCmdDataSourceType="ADO" and UpdateCmdDataSource=< ADODB.Command object >, same for Insert/Delete related properties. If you don't do this, CursorAdapter updates the Recordset and doesn't use UpdateNameList and other related properties.

Also, you should be able to find many other CursorAdapter related examples here on UT.

Thanks,
Aleksey.