By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,434 Members | 2,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,434 IT Pros & Developers. It's quick & easy.

Subform not linking to Main form

P: 2
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???
Aug 6 '07 #1
Share this Question
Share on Google+
2 Replies


hyperpau
Expert 100+
P: 184
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. :)
Aug 20 '07 #2

Scott Price
Expert 100+
P: 1,384
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
Aug 21 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.