how to use a subform to add more information

[Toeying]

Hello, I am trying to use a subform to get some extra information about my contacts. for example for a parent, have a command button to open the subform to add a child. I need this subform to pick up the parents ID and then save the childs details in the child table.
Also in view mode, I want the subform to pop up with the details of every child linked to the parent.
I know how to add the subform to the main form but, I don't know how to get the parents ID to be linked with the "add child" subform. Thanks a mill

Toyin

 

[Galaxiom]

Set Master Link Fields and Child Link Fields propereties of the subform control to ParentID.

 

[Toeying]

well, the sub form is not embedded on the main form so masterlink and child flink dont appear in the properties. I am using a pop up subform opened by a command button. thanks

 

[Galaxiom]

As it is not shown in a subform control it isn't a subform.
For a popup form use the WhereCondition argument of the OpenForm method.

http://msdn.microsoft.com/en-us/library/aa220276(office.11).aspx

 

[Toeying]

Brilliant Galaxiom. Thanks a million.