SQL Stored Procedure And A Form Recordset

[Moonshine]

Hi All

Im having some Major issues with this problem, i only hope someone can help me!!

Firstly, let me set the scene. I have 1 Form, And 1 Subform within that form. The form gets the Main Data, the SubForm gets all the Related Data (in this case, its all the Items Of Equipment this client has) and then lists them in the subform. So it could return 1, or it could return 20 records.

What we want from this is to be able to record what the client thought of the piece of equipment, so there is a Option Group on the SubForm, which allows the user to choose 1 of 6 options saying whether it was useful or not and things.

BUT here lies the problem, if the SubForm has returned 20 records, i change the OptionGroup on record one, and every other 19 records become the same. if i change Record 2, record 1 and 3 to 19 are the same.

I want to be able to have a seperate choice for each record returned, but tis not working!!

The subform is populated by calling a SQL SP, i cant set the form to link directly to a view or SP because access doesnt allow me, by saying the recordset is not updatable!

I hope all that makes sense!!

 

[gromit]

Hi -

My knowledge here is incomplete, but I'll at least offer what I know.

I think the problem you are getting with the option group is because when Access displays a subform there is one instance of the unbound control. So you are not looking at 20 OptionGroups, but the same one.

You can bind the option group to a field in your subform table and this should eliminate the issue.

2. The message about the recordset being not updatable means that you have created a recordset that has an aggregate of some fields. Access can't update the recordset because it can't match what you are seeing to a single record in the db.

hope that helps,

- gromit