Problem with Access 2000 forms

Hi!

I have an Access 2000 project (.adp) file. This is connected to the SQL Server database. I have a form, which has a lot of fields. The forms record source is set to a stored procedure.

Only one control on the form txtSSN is bound to a field (SSN), that is obtained when the stored procedure is executed.

Based on the SSN, I retrieve all the other values and assign it to the rest of the controls on the form.

I have a problem here. After retrieving all the values from the database, and assigning it to the respective controls on the form, I should be in a position to edit it(if i have to)

but i am not able to.....could someone tell me why...........


also if i am using a bound form, wherein all controls are bound to fields retrieved from the stored procedure, and if i try to edit it, the form displays a message at the bottom of the screen "RECORDSET NOT UPDATABLE". why am i getting this...........


PLEASE HELP!!!!!!!!!!!!!!!!!!!!

Check your recordset type to make sure it is Dynaset and that
the Record Locks is Edited Record. Also, check that your stored
procedure recordset comes from only one table. Fields can only
be updated through queries if they contain one table or the fields
to be updated are located in one table. If I remember correctly.

HTH

the stored procedure is pulling from more than one table. Is there no way in which I can solve the problem?

PLEASE HELP!!!!!!!!!IT IS URGENT