subform link to mainform (1 Viewer)

[AljayB]

hello,
I am just wondering if there is a way that one can create such a link between a subform and a main form, that if you select a field in the subform it would display the corresponding data to the main form?

I belive that could be done with the on enter or on exit event, however I am not that skilled in writing a vba code.

many thanks in advance!

 

[Grumm]

What kind of subform will it be ?

I had a similar problem. I ended up with deleting the subform and just adding a list box on the main form where the user can select the correct record.
(My was here : http://www.access-programmers.co.uk/forums/showthread.php?t=282858. Never got a usefull answer to get it working with a subform...)

 

[gemma-the-husky]

@aljay

this sounds like a wrong concept. the point is that the subform is dependent on the mainform. There should not be any part of the subform that needs the mainform to navigate to a different record.

the mainform is actually the parent of the subform, so you can refer to the parent (parent! or parent. depending) from the subform.

what exactly are you trying to do?