Hello everyone

I am having trouble with a form that I made. I created 4 tables and created relationships where i could view each advisor, what their role is, and what goals they need to accomplish. Furthermore i created a goals table and action items tables. The idea is to relate all action items to each goal. SO when I made a form where the goals form and action items form are linked, my problem was that the action items dont automatically link to each action item. What happens is that when I scroll through my form, whatever goal which happens to be highlighted has its corresponding action items but if there are more than one goal that has action items it doesnt link up. Is there code where I can make all my action form auto update with my goal form depending on where I click. Any help would be appreciated.

mhall-
Welcome to the Forum.
What tables have you created already and what are the relationships between them?
(It sounds like you have Advisors, Goals and Action Items?)
Loralee

Hi Loralee

Thanks for responding to my query. Yes I have created an Advisors table, a goals table, and an action items table. I have relationships between my "advisor ID" field in my advisors table to my "Advisor ID" field in my goals table. From my goals table I have a relationship from "Goal Id" field to my "Goal ID" field in my Action items table. What I need to reflect is each action items that corresponds with the goals. What happens is that there will be two goals in my goals subform but in my subform action items there will only be action items that correspond to one of the goals. I want to be able to click on the other goal and have my action subform auto update or something of the like. Is my problem possibly stemming from the fact that I am using Pivot subforms?

Thanks

Hi MHall,
So let me see if I am following: You have Advisors table which relates to Goals as 1:many; a Goals table which relates to ActionItems as 1:many??? It sounds like you have nested the ActionItemsSubform onto the GoalsSubform which is on the AdvisorForm? If so, are the LinkChildFields and LinkMasterFields set up on the ActionItemsSubform? (What version of Access are you running?)

Loralee

You are correct. I am running the latest version of access. However I have been unable to locate the linkmasterfield and linkchildfileds where I can dictate the relationships between forms. When I go to detail mode and click properties the linkmaster, child fields arent there.

Mohirah

Hi Mohirah,
Okay, I'm going to assume you haven't set them then. One important question first- Did you base your Advisors, Goals and ActionItems forms/subforms on a table or a query?

The LinkChildField and LinkMasterField are on the Property Sheet for the subform. To get there:
1) Open your form in design view. 2)Click on the subform (one click only). 3)The Property sheet should say "subform" & whatever you named it. 4) go to the "Data" tab of the Property Sheet. Please tell me what the LinkMasterField and LinkChildField and ObjectSource properties say. I'll check in later....

Loralee

Hey Loralee

It turns out I havent set the linkmaster fields yet. The default on my action items which is the second subform is "goal id" for linkchildfield and "[Team Goals Subform].Form![Goal ID]" for link master field. For the goals form, which is the first subform the linkchildfield and master are both "advisor id". Also I am basing these forms off of tables and not queries. Thanks again for your help. If i dont respond to your next reply its probably because I left work and I will respond ASAP on Monday morning.

Mohirah Hall

Mohirah,

Were you able to get your subform to work?

Loralee