Update Control on continuous subform

[JaneC]

I have a continuous subform with a combo box which is dependent on the contents of another combo on the same subform. The problem is that when the second combo box updates itself this applies to all instances of the subform. Is there any way to get the update to only apply to one row of the subform. Apologies if this has been covered before but I've searched for it and haven't found anything !

Thanks

Jane

 

[Sameal]

I would believe you would have to put some code in OnCurrent on the subform to requery the combo boxes every time you move to a new record. However I believe as soon as you do the records that you've already set will no longer show their contents as their value is not in the list. Small problem however as the data is still in the tables, just makes it look bad.

I did something like this and to fix the problem I split things up into different forms. Depends on your situation as to how you could possibly split everything apart into different forms. Maybe instead of having a subform, have a button on the main form that leads into another popup form which has your entries on it. I don't know how you can make each record in the subform have different sources for their data.

 

[JaneC]

Thanks, I have the code to update the second combo on the On Change event of the first combo. I think I will have to have a popup form as you suggest to edit these values.