Form / Subform Link?

[JZII]

Hi...

In my database I have a form with misc. company information. (like a big adressbook)I use next/previous post buttons to browse the different posts. (that shows one by one)
All of the companys are listed under various categories. When I click on a category the subform shows all companys in the same category. But regardless on which post I click on in the subform I only see the post marked in the orig. form. What I would like to do is...

When I click on a post on the subform, I want the same post to show on the baseform...

Can anyone help me... JZII

 

[RFletch]

Hi,

In the properties of your subform should be 'Link Child Fields' and 'Link Master Fields'
You need to set these up properly (click on the build button on the right and the wizard should take you through it).

RFletch

 

[JZII]

So far OK... When I click on a post in the baseform the subform changes as I want... But I want to click on a post in the Subfrom to change the post in the baseform...
I cant do that in the Linkmaster/child properties field.. The only thing availible is how to control the subform via the baseform... JZII

 

[JZII]

Anybody? Please help me! JZII

 

[Shortie]

It's me again

On selection of item on subform run this code

Dim varItemToLocateOnBaseForm
varItemToLocateOnBaseForm = FieldOnSubForm

Form![BaseForm]![FieldToFind].SetFocus
DoCmd.FindRecord varItemToLocateOnBaseForm, , , , , acCurrent, True