[AccessD] Push Data

Joe,

If the subforms are linked to the parent form, the related records
should show up automatically ... Or are you talking about something
else?  Is this on existing or new records in the parent and child forms?
You can use code to fill in values, but it's generally a better idea to
let the child form retrieve the values rather than having it manipulated
from outside.  I'm not clear on the scenario you envision, so I may just
be confusing you.

Charlotte Foust


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Wednesday, January 11, 2006 8:41 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Push Data


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

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