Playing off of:
If I'm using ADO, how would I add/modify/delete records from a recordset creating using a Join?
Not looking too much for specifics at the moment...just general ideas/commands. I've always use Select statements and then assigned the fields with the text control's data...presumably I would use INSERT and DELETE commands?
If so, in addition, I want to cover all the bases so that if an add is initiated, the user has the option to cancel the add - an undo for an edit, etc...are these ado commands that I can apply? Any links with tips for these procedcures?