Unbound subform linking

[dynamictiger]

I have a subform which is unbound. It has to be unbound to build the query as the returned values can change and are not known at development time.

On the main form I have a field txtClientLink. The underlying query contains several functions including one to return the value of txtClientLink.

Due to the functions I cannot fool access into letting me bind the subform to the main form in a parent child relationship. It won't recognise the fields at all, even if I leave the query in place.

Is there a way in code to set the parent child relationship from the subform on populating?

 

[Darrylles]

Hi,

Why not define the child/parent links at runtime, set them when needed.

They are properties that can be referred to as any other.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[dynamictiger]

Setting from the subform would look like????