Hello all,
Have not been here for long time. I would very much appreciate if someone can help me with such issue. There a form with linked subform, the subform is in datasheet view. On the subform there is a drop down box which provides the values for the field based on the selection of another field on the same subform.
here is the SQL:
SELECT Sizes.ID, Sizes.Size FROM Sizes WHERE (((Sizes.CatSetID)=[Forms]![Add Employees]![EE_sizes subform].[Form]![PPEID]))
But to be able to update the source data depending on the the field selected ( PPEID ) I had to set me.requery on change of PPEID event. Well it does the trick but clears the displayed values on previous lines. How can avoid this ?
Have not been here for long time. I would very much appreciate if someone can help me with such issue. There a form with linked subform, the subform is in datasheet view. On the subform there is a drop down box which provides the values for the field based on the selection of another field on the same subform.
here is the SQL:
SELECT Sizes.ID, Sizes.Size FROM Sizes WHERE (((Sizes.CatSetID)=[Forms]![Add Employees]![EE_sizes subform].[Form]![PPEID]))
But to be able to update the source data depending on the the field selected ( PPEID ) I had to set me.requery on change of PPEID event. Well it does the trick but clears the displayed values on previous lines. How can avoid this ?
