[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


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com