Hey all,
We just acquired a new machine which has the new office XP on it which uses Access 2003. We have been using an application to handle our Time Entry. This application uses a subform of continuous forms. The first field that is required is the job that the person was working on, so the user chooses the job from a drop down list. The value of that control is used in the view that the next drop down list control is based on:
SELECT tblphase.PHASEID, tblphase.PHASE, tblphase.PHASEDESC, tblphase.CLASS, tblphase.ORDERNUM AS [order]
FROM tblphase
WHERE (((tblphase.ORDERNUM)=[Forms]![frmTimeByEmp].[frmSubTime]![Order] Or (tblphase.ORDERNUM)="----"))
ORDER BY tblphase.PHASE;
The gotfocus event of the second control called a requery which properly supplied the list of phases associated with the selected job(ordernum).
For some reason, in the 2003 version, this process no longer works. The second control never gets populated with the phases. I have been banging my head against this problem for two days. Anyone with any suggestions as to why this is happening and better yet, how to fix this problem, please respond.
We just acquired a new machine which has the new office XP on it which uses Access 2003. We have been using an application to handle our Time Entry. This application uses a subform of continuous forms. The first field that is required is the job that the person was working on, so the user chooses the job from a drop down list. The value of that control is used in the view that the next drop down list control is based on:
SELECT tblphase.PHASEID, tblphase.PHASE, tblphase.PHASEDESC, tblphase.CLASS, tblphase.ORDERNUM AS [order]
FROM tblphase
WHERE (((tblphase.ORDERNUM)=[Forms]![frmTimeByEmp].[frmSubTime]![Order] Or (tblphase.ORDERNUM)="----"))
ORDER BY tblphase.PHASE;
The gotfocus event of the second control called a requery which properly supplied the list of phases associated with the selected job(ordernum).
For some reason, in the 2003 version, this process no longer works. The second control never gets populated with the phases. I have been banging my head against this problem for two days. Anyone with any suggestions as to why this is happening and better yet, how to fix this problem, please respond.