Michael Brösdorf
michael.broesdorf at web.de
Wed Apr 28 11:31:14 CDT 2004
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