Subform not linking to Main form

[rlamber]

Hello,

I have 2 subforms in a Main form, one links fine, the other doesn't. I am trying to link them both to a "tracking ID" on the main form. The Tracking ID is a text field that is a combination of an auto-number and an Alpha expression. The subform that links fine is a comments form (continuous form with just date field and memo box) and the subform that won't link is a larger, more detailed form where I would like to add more than one "Action Plan" to the item on the main form. The parent/child relationships on both are tracking ID to tracking ID. They are also linked by tracking ID in relationships. I didn't do anything different with the Action Plan form as opposed to the Comments form except the continuous form part, so I can't figure out why one works and the other doesn't. I've tried to make it a continuous form, too, and it still doesn't work.

My primary keys are auto-numbers in each table and I just added a tracking ID field to each table for linking purposes.

I have checked it over and over and can't see anything I'm missing, but can't figure out why the information in the Action Plan form will not show up in it's appropriate Tracking record??? Maybe I'm missing something???

[hyperpau]

Hello,

I have 2 subforms in a Main form, one links fine, the other doesn't. I am trying to link them both to a "tracking ID" on the main form. The Tracking ID is a text field that is a combination of an auto-number and an Alpha expression. The subform that links fine is a comments form (continuous form with just date field and memo box) and the subform that won't link is a larger, more detailed form where I would like to add more than one "Action Plan" to the item on the main form. The parent/child relationships on both are tracking ID to tracking ID. They are also linked by tracking ID in relationships. I didn't do anything different with the Action Plan form as opposed to the Comments form except the continuous form part, so I can't figure out why one works and the other doesn't. I've tried to make it a continuous form, too, and it still doesn't work.

My primary keys are auto-numbers in each table and I just added a tracking ID field to each table for linking purposes.

I have checked it over and over and can't see anything I'm missing, but can't figure out why the information in the Action Plan form will not show up in it's appropriate Tracking record??? Maybe I'm missing something???

try to remove that subform and readd it using the access wizard so that we can know what is causing the error. access wizards usually tells you if something is wrong with your setup.

sorry, that is all i have to say right now. :)

[Scott Price]

So you have your subform based on a query, or a table?

Query would be far more flexible, allows to enter the criteria you want in the query design view: i.e. =Forms![YourMainForm].[TrackingIDControlName]

This will then tell the query to display the records you want to see.

Then all you need is a Forms![YourMainForm]![YourSubForm].Form.Requery command in the afterupdate event of your TrackingID control to requery the subform and thereby show the appropriate records.

Regards,
Scott