PDA

View Full Version : ACCESS has done it again! Dynamically loaded forms



mud2
03-10-2009, 07:03 PM
As usual, ACCESS led me down the rock-riddled primrose path! I finally figured out how to dynamically load a master form AND subforms. ...Until I tried to ENTER data in a field in the subform!
My master form contains record navigation and add. save buttons. Child forms are based on data tables.
The master and child fields are linked...through "Name". The Navigation buttons work fine, but when I try to add or save a new record to a subform I get a pop up box asking for the "Name" parameter.
SO, back to my diet of worms!
I've tried the "allow edit"...options in the child forms...nothing. My "DoCmd.OpenForm command includes acEdit......

mud2
03-10-2009, 08:03 PM
When ACCESS opens one door, it slams shut several others!

CreganTur
03-11-2009, 10:57 AM
Have you considered using ADO's Execute method to run action queries in order to append or update records in your tables? Given what you're trying to accomplish, and how difficult dynamic subforms can be, it might be a good option.