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!!!!!!!!!!!!!!!!!!!!