Subform

[vr]

I have a Mainform (one) with a Subform (many). The recordsource for each is an SQL statement to an Oracle database.

Each field is then set to the rs("field).value.

The Mainform works fine. The Subform does update the fields consistently.

Can anyone tell me how to correctly set the recordsource and linkparent/linkchild fields. This does not appear to be the same with an SQL recordset. The tables from Oracle can not be linked into the database (management decision).

Any assistance would be greatly appreciated.

Thank you!!

 

[jurgen]

In thee property of the subform, did you enter the master/child fields ?

JJ

 

[vr]

No. These are both unbound forms. I need to know how to do this in code.

 

[TTThio]

If you are trying to set the master/child link fields using the "..." button, it'll give you message that you cannot set a link between unbound forms.

But actually you can, just by typing directly to the property, don't use the "..." button. It will link the main and child forms. Just remember the data type of the main and child fields that is linked have to be the same.

Good luck!

Tin Tin