Subforms in Access 2000 using SQL Server as the backend

Hi!

We are in the process of migrating from Access 97 to SQL Server. All the applications in Access 97 are being migrated to Access 2000 (.adp). How can I do subform creations in .adp files.

I have an Access 97 form/subform that is based on a query. when i converted this form/subform to Access 2000(.adp), i set the record source object to a stored procedure. But I cannot edit anything. It gives a message "Recordset not updatable"..........

can someone provide an alternate solution to this.........

please help......am working on a project with a deadline