Form/Subform Data Entry/Synchronization

[WhyMeAndNotYou]

Application is a survey data entry form containing several sections with more data elements than can be contained on a single form.

Desired solution: make each section its own table linked in a one-to-one relationship on a record_id field. Create a subform for each table. Then create a Master Form to which each of the subforms are linked. When a new record_id is entered into the Master Form (its only element), a new record would be created for each table with this record_id and data could be entered via the subforms.

Problem: Data synchronization.

Questions: Is it possible to achieve the desired goal with little or no VBA coding? If possible, what would a sample of the code look like?

 

[EstuardoSierra]

Why the problem is data sinchronization?
You're saying that after the main form its being filled with the id all child forms will get that id. am i right?
If so. this is the smaller of your problems.
You don't want code involved, enven so, i belive is possible you can achive your goal with many macros and MANY different kinds of qrys, (append, delete, update etc) as needed. But that's somethign that i honestly wont recommend.

Good luck

Estuardo