Michael Brösdorf
michael.broesdorf at web.de
Thu Apr 29 07:38:29 CDT 2004
Hm, to make any statement I would need more information about your data structure. If you want you can send me a sample app and I will take a look at it. Michael -----Ursprüngliche Nachricht----- Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Douglas Barnes Gesendet: Mittwoch, 28. April 2004 20:16 An: Access Developers discussion and problem solving Betreff: RE: [AccessD] Subform to Subform Updating I have the hidden control on the main form, sorry 'bout that. sub2 does indeed return the correct data. Problem arises when i try to add another record in sub2. Douglas Barnes Starn Technical Services P. O. 1172 Meadville, PA 16335 814.724.1045 doug at starntech.com www.starntech.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Michael Brösdorf Sent: April 28, 2004 12:31 PM To: Access Developers discussion and problem solving Subject: AW: [AccessD] Subform to Subform Updating If sub2 is a subform of the main form (i.e. not a subform of sub1), sub2 does not 'see' anything entered in sub1 since it is linked to the main form. However, if you put an (invisible) textbox on the main form, that contains the primary key of sub1, you can link sub2 to that textbox on the main form. If you now select a record in sub1, it's primary key will show up in the textbox. Sub2 will then in turn related data. HTH, Michael -----Ursprüngliche Nachricht----- Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Douglas Barnes Gesendet: Mittwoch, 28. April 2004 18:04 An: AccessD at databaseadvisors.com Betreff: [AccessD] Subform to Subform Updating I have a main form with 2 subforms (sub1, sub2). I can add records to sub1 as it is related to the main form. I can't seem to add records to sub2, which is related to sub1. Any insight on this would be appreciated. Douglas Barnes Starn Technical Services P. O. 1172 Meadville, PA 16335 814.724.1045 doug at starntech.com www.starntech.com -- _______________________________________________ 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com