title: Subforms integration not working seamlessly in Ms Access 2010
body: <p>I have a form in MS Access 2010 with two sub forms in it. I've defined one-to-one relationship with the tables behind the forms. Both the sub-forms should be used to create a record in corresponding tables and then update the foreign key in the parent form. But when I fill the sub-form first, an entry is created in the corresponding table but the foreign key doesn't get updated. Shouldn't this happen automatically? Or should I add code for updating parent form's field?</p>
  
  <p>Also when I start filling the main form first and then jump to any of the sub-form, I get the following error message:<br>
  "You must enter a value in the 'Activations.dbBoxID' field" (Activations is the main form here and dbBoxID is the foreign key field.)</p>
  
  <p>Another issue is that I don't want sub-forms to update the corresponding tables until an entry in main table is also created (i.e. all required fields in main form are also filled).</p>
  
  <p>I am new to MS Access. Any help would be really appreciated!</p>