B
Brian Snelling
Hi,
Working with Access97 and Win XP. Main form is "frmDailyRecords",
subform is "fsubDailyRecordDetails" Main form has combo boxes for "Project"
and "EmployeeName" and various text boxes for other info. Subform has a
combo box to select a block (work area ) from tblBlocks. There is a field
"ProjectID" in tblBlocks (foreign key from tblProjects) so each block has an
association to a project. I want to limit the dropdown contents of cbxBlock
to the right ones for the project selected. I've tried to use the technique
from the MS knowledge base #98660 but have some problems. Contents of the
dropdown list do not change with a change in Project - if I change project
and the close and reopen the form the list will change but records already
saved to any not selected project show blank for the block field.
Hope I've been clear enough here. Any help very welcome.
Brian S.
Working with Access97 and Win XP. Main form is "frmDailyRecords",
subform is "fsubDailyRecordDetails" Main form has combo boxes for "Project"
and "EmployeeName" and various text boxes for other info. Subform has a
combo box to select a block (work area ) from tblBlocks. There is a field
"ProjectID" in tblBlocks (foreign key from tblProjects) so each block has an
association to a project. I want to limit the dropdown contents of cbxBlock
to the right ones for the project selected. I've tried to use the technique
from the MS knowledge base #98660 but have some problems. Contents of the
dropdown list do not change with a change in Project - if I change project
and the close and reopen the form the list will change but records already
saved to any not selected project show blank for the block field.
Hope I've been clear enough here. Any help very welcome.
Brian S.