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

Autopopulate Subform data

P: 2
Hi I have a main form in which I have linked subforms on tabs..
My problem is that I have one subform which is linked to a table which has 2 to 6 sessions in one table, we are required to fill out a feedback form for each session. So I have put hidden 6 tabs with subforms on each tab linked back to tbl_feedback.....

So far I have it set up so that when a date field next to a session number on first tab is changed it opens appropriate tab with feedback sub on it... I can get it to create a new record in feedback sub, but if I go back and change date next to session again the corrct feedback sub tab opens but shows first record in feedback tbl based on main form link... I need it to autopopulate the sub fields with data from tbl based on one value in sub.

Such as when date first changed on session 2, new Feedback ID is created 645... change session 2 date again it goes back to 638...
Jul 25 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 374
Can you please post table and query structure and how you have them related to each other on the Form as well as include name of controls on form and what they are bound what fields in the tables or queries.

This would be a lot easier to try to diagnose if I had the necessary info. Since I don't know the level of expertise with MS Access, I have to assume that the way that you've set up the relationships between the tab control and each of the controls on the respective tab, you're going to run into trouble because your trying to do a 1 to many relationship, but not telling which item (record) go on what tab, and that is why it is displaying your record in any and or all sub tabs that you may select.

If you can post that information, and also any VBA code that you may have written, this would give a better idea of what needs to be changed to make it work the way you want.

Hope that helps,

Joe P.
Jul 25 '08 #2

P: 2
Many thanks Joe.... yes have worked it out, I was trying to autopopulate a PK field... just created an unbound txt field and used this.
Jul 28 '08 #3

Post your reply

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