Combo Box Problem On Continuous Form 1

[Grumm]

Hi,I have a form that contains a sub form with a number of combo boxes. The main form holds project information. The sub form holds task information for each project. These 2 forms are linked and work correctly.

Two of the combo boxes in thye subform are:-
WorkGoupTypeID and WorkTypeID - these can be different for each project.

Depending on the selection in WorkGroupID I want the selection list in WorkTypeID to be different. The valid values are for example: -

WorkGoupID: Measured Works and Prelims
WorkTypeID Brackets Management
Panels Quality Assurance
Finishings

I have built the combo boxes and when I refresh the records the comboboxes refresh correctly.

My problem is that the boxes are updates for all records in the continuous form. I want it to refresh record by record.

Any Ideas would be great - been struggling with this for a week.

Cheers


Grumm

 

[redapples]

I think I was having a similar problem.

If it is the same problem as I had then I might be able to help. After struggling with this for a while I came up with a solution which is now a FAQ
faq702-3679

let me know if this is indeed the same issue.

redapples