Have posted a similar question over in the Forms forum but this may be more relevant to Tables:
http://www.access-programmers.co.uk/forums/showpost.php?p=1018824&postcount=16
It would seem I should not be running multiple subforms over multiple tabs from the same record source. Does anyone have any recommendations on how to lay my tables out given that I'd like to maintain the current form design?
Two possible solutions:
1) split the subforms related table into groups dependant on the data in the tabs and link them all back to the one junction table.
2) split the tables as above and create individual junction tables for each.
My prefered option would be No 1 above but would having one junction table still cause problems with the record source as it'll still be needed in my queries to link back to the main form record source.
Thanks in advance.
http://www.access-programmers.co.uk/forums/showpost.php?p=1018824&postcount=16
It would seem I should not be running multiple subforms over multiple tabs from the same record source. Does anyone have any recommendations on how to lay my tables out given that I'd like to maintain the current form design?
Two possible solutions:
1) split the subforms related table into groups dependant on the data in the tabs and link them all back to the one junction table.
2) split the tables as above and create individual junction tables for each.
My prefered option would be No 1 above but would having one junction table still cause problems with the record source as it'll still be needed in my queries to link back to the main form record source.
Thanks in advance.