I have an on-going problem with a cascading combo box. It is saving the information in the table but droping it from the split form.
In this set of talks it referes to while discussing the split from
http://www.access-programmers.co.uk/forums/showthread.php?p=1190375#post1190375
"enter a breakpoint and step through" I have no idea what that even means. I have only managed to get the cascading combo working by carefully copying a demo language and have no idea what is wrong and why the form keeps dropping the information.
the other link for the problem
http://www.access-programmers.co.uk/forums/showthread.php?t=233377&goto=newpost
One problem is tied to another. If I use this in an unbound box control source: =Nz(DLookUp("[TotalCredits]","qryUnitTotal"),"") see query below
the cascading combo is stable. it works in that it gives the total of record1, however if I add a record 2 it still gives only the total for record 1 instead of the total for record 2.
If I use a subform and enter the query on that, I get the correct total
SELECT Sum(tblCourseTaken.Units) AS TotalCredits, tblCourseTaken.[790ID]
FROM tblCourseTaken
GROUP BY tblCourseTaken.[790ID], tblCourseTaken.CourseStatus
HAVING (((tblCourseTaken.CourseStatus)="Completed"));
but then the split form drops the information.
In this set of talks it referes to while discussing the split from
http://www.access-programmers.co.uk/forums/showthread.php?p=1190375#post1190375
"enter a breakpoint and step through" I have no idea what that even means. I have only managed to get the cascading combo working by carefully copying a demo language and have no idea what is wrong and why the form keeps dropping the information.
the other link for the problem
http://www.access-programmers.co.uk/forums/showthread.php?t=233377&goto=newpost
One problem is tied to another. If I use this in an unbound box control source: =Nz(DLookUp("[TotalCredits]","qryUnitTotal"),"") see query below
the cascading combo is stable. it works in that it gives the total of record1, however if I add a record 2 it still gives only the total for record 1 instead of the total for record 2.
If I use a subform and enter the query on that, I get the correct total
SELECT Sum(tblCourseTaken.Units) AS TotalCredits, tblCourseTaken.[790ID]
FROM tblCourseTaken
GROUP BY tblCourseTaken.[790ID], tblCourseTaken.CourseStatus
HAVING (((tblCourseTaken.CourseStatus)="Completed"));
but then the split form drops the information.
