Help with subform issue

[lilFlip]

Hi,

I've been pulling my hair out for hours now trying to figure this issue out. I have a form that has 2 tabs on it, the first tab contains user data and the second one is a subform which retrieves all security records for the selected individual. I can get the form to populate fine, but for some weird reason when I select a record on the subform, I am not able to select another record. It appears to be locked/stuck on the first selected row. I am populating the subform with a disconnected recordset.

I've looked through all the properties of the subform/form and cannot determine why it will not let me modify more than one row/record at a time...can someone help me. I'm sorry if this is a stupid question and that I am over complicating things.

Thanks in advance....

 

[lilFlip]

Ok, here's another issue...I've tried using the Filter property instead of the disconnected recordset, and well I can edit multiple records that way but...

the problem is I don't want the records saved to the db until the user has finished all changes and then pushes the save button...

any ideas? Help?

 

[KeithG]

You can do transactions in Access with VBA. Look up BeginTrans, Rollback, and ComitTrans in VBA help (not Access help).

 

[lilFlip]

Yeah, I can handle the transaction processing through the ADODB recordset object. I have no problem with that, but with the subform created in Access, it doesn't allow you to leave the row once it has focus.

I'm guessing there is a difference in how the subform container responds when it has a query attached rather than a recordset object.

Any ideas?