After crawling through the labyrinth of subforms, synchonization, querydefs (three levels of them) to arrive at the promising land of a functional database with multiple subforms complete with cascade update and delete and even an on error or two, I ventured further and struck out for the promised land of querying with subforms included. Ahh! The joy when even that met with success. So now maybe you appreciate my agony when I find that while I can edit the query result in the subforms without a problem, the main form I cannot edit. Non updateable the horrible little message says.
Obviously because the record source of the subforms hasn't changed, just the main form. Is there a way to edit a table from a query result displayed in the main form or is that like putting toothpaste back in the tube? Are queries one way streets? Any suggestions would be more than welcome.
The code doesn't show anything except the method used to open the form.

Obviously because the record source of the subforms hasn't changed, just the main form. Is there a way to edit a table from a query result displayed in the main form or is that like putting toothpaste back in the tube? Are queries one way streets? Any suggestions would be more than welcome.
The code doesn't show anything except the method used to open the form.
Code:
'change recordsource
Forms!ALLDISP.RecordSource = "qrytmp3"
DoCmd.OpenForm strParentForm, acNormal, , , acFormPropertySettings