Hi,



This is my first time of of using as access project with an SQL (7.0) 

Database.



I'm currently having problems with refreshing my form with records found 

while using ADO recordsets. 



I've used the clone method to set the forms recordset to ADO recordset 

before performing the find. But the forms recordset doesn't seem to be 

updateable in any form as the values do not change (as seen while using 

the debugger/addwatch). Using jet. 4.0 is not a problem at all as this 

works smoothly. Please i need some assitance.



This is what i have presently:

1)I'm using an acess project (Access 2000)



2)My Database is MS SQL 7.0 (DeskTop Installation i.e Server and Client  

both reside on my notebook) 



3)My forms recordsource are pointing to the tables in the SQL database

i.e i'm not presently using stored procedures or triggers to do any 

INSERT,DELETE,UPDATE, etc





Secondly, I also notice that when entering new records, all new records 

are not updated instantly in queries used in my Combo Boxes which are 

directly derived from such tables. Until the form is entirely closed and 

reopened before the queres in the Combo Boxes are updated. How can this be 

solved



Regards



Gerald Oki