Karen Rosenstiel
karenr7 at oz.net
Thu Jul 27 21:29:30 CDT 2006
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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com