ShaneBrennan
Programmer
Hi guys
I've successfully managed to solve my problem of taking information from a table into a crosstab, edit and update this information and place it back in the original table.
However. I want to place the table, called tblResultsGrid, as a sub-form in data view. I've managed to create a sub-form in dataview and add it to a main form and it works beautifully. However if I want to display details for an other course, the assignment codes change, therefore the sub-form goes to pot cause the fields names/Data Source has changed.
Is there an easy way to automatically add/delete/ammend fields on the sub-forms so it will display the correct fields - when I scroll through the courses.
Any help would be appreciated
Shane
Shane Brennan
Shane.Brennan@tcat.ac.uk
I've successfully managed to solve my problem of taking information from a table into a crosstab, edit and update this information and place it back in the original table.
However. I want to place the table, called tblResultsGrid, as a sub-form in data view. I've managed to create a sub-form in dataview and add it to a main form and it works beautifully. However if I want to display details for an other course, the assignment codes change, therefore the sub-form goes to pot cause the fields names/Data Source has changed.
Is there an easy way to automatically add/delete/ammend fields on the sub-forms so it will display the correct fields - when I scroll through the courses.
Any help would be appreciated
Shane
Shane Brennan
Shane.Brennan@tcat.ac.uk
