[AccessD] Synchronize popup

Karen,

    My sample db named FormsSynchronized might be of interest to you. It is available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
 
    Two styles are covered: 
    (a) Two subforms (Master & Slave)
    (b) Two normal forms (Master & Slave)

    Style (b) should be pertinent to the situation mentioned by you. You could adapt the underlying approach suitably, for your specific needs.
 
Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Karen Rosenstiel 
  To: 'Access Developers discussion and problem solving' 
  Sent: Friday, July 28, 2006 07:59
  Subject: Re: [AccessD] Synchronize popup


  Ah.....um......

  JC, I don't know what you're talking about. You are way too advanced for this amateur. 

  Actually, I get the feeling sometimes that you are too advanced for many of the PROFESSIONALS on this list.

  But thanks anyway.

  Regards,

  Karen Rosenstiel
  Seattle WA USA 


  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
  Sent: Thursday, July 27, 2006 1:37 PM
  To: 'Access Developers discussion and problem solving'
  Subject: Re: [AccessD] Synchronize popup

  Use Withevents / Raiseevents.  Raise an event in the form that is the main form, in OnCurrent.  When the popup opens, dim a form variable, set it to the pointer of the main form, then build an event handler for that form.
  >From then on, when the main form raises it's event, the popup form will 
  >sink
  the event and do whatever you want it to do. 


  John W. Colby
  Colby Consulting
  www.ColbyConsulting.com

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
  [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of karenr7 at oz.net
  Sent: Thursday, July 27, 2006 2:44 PM
  To: accessd at databaseadvisors.com
  Subject: [AccessD] Synchronize popup

  Dear gang,

  I am working on a database to track medical records that are sent to the
  wrong medical providers.

  Three tables: tPatient, tErrors, tChecklist.

  Relationships: tPatient.PatientID (PK one-to-many)-->tErrors.ErrorsID (FK
  one-to-one) --> tChecklist.ErrorID

  The main form is fPatient with fErrors as a continous subform and fChecklist as a popup to fErrors. The popup is not picking up the FK from tErrors.ErrosID. I know how to synchronize a subform within the main form, but how do I syncronize a popup to its master form, which is a subform? I want it to syncronize continually, not just on open.

  Thank you.

  Regards,
  Karen Rosenstiel
  Seattle WA USA