Joe Hecht
jmhecht at earthlink.net
Wed Jan 11 10:40:50 CST 2006
I want the user to select an employee and then it will in various fields in the parent and child forms. Joe Hecht jmhecht at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, January 11, 2006 8:34 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Push Data What do you mean by "push data"? Ordinarily, you pull data from the parent from into the child form. In code, it's simply Parent!controlname to reference a value. You can set the default value of a textbox on a child form to "=[Parent]![EmployeeID]" (without the quotes), for instance. Does that help? Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht Sent: Tuesday, January 10, 2006 8:23 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Push Data My head still hurts from the DateDiff fight I had over the weekend. I am going to have a master form and many sub forms on a tab control. What issues do I want to look out for in trying to push data from the parent to various sub forms. I want to not duplicate data in other tables. Selecting one employee, I want to fill in various information. Thanks in Advance. Joe Hecht jmhecht at earthlink.net -- 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