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...