Changing Form Recordsets

[rwilson32]

I have a form that contains a subform. I have a combo box inside the main form and when the user selects a certain value inside the combo box I change the recordset for the subform based on that value. I do this by opening a DAO recordset and setting the subforms recordset equal to this recordset. The problem that I have is that in the subform, I have it set to display as continuous forms, so it shows all the records that relate, but after I change the recordset I can no longer add new records in the subform. It looks like it will and I can type in a new one but it does not store it. So the question I have is how do I get this subform to accept a new record. Thanks for any help.

 

[dcx693]

The recordset for the subform must be updateable. Can you give us an example of what you change the subform recordsource to? For example, if you return a recordset that is the result of aggregate functions, you obviously won't be able to update those.