Subform multi-select lost when focus is moved to another control

[smbrush]

I'm developing a form with a subform in datasheet view. When I select multiple rows in the subform and then move the focus to another control on the form, the row selection in the subform changes to just the first row in the original selection. For instance, if I select three contiguous rows in the subform using the record selector and then click on another control, the selection changes so that only the top row in the original selection remains selected. The two rows below cease to be selected.



Does anyone have any ideas on how to prevent this loss of row selection in the subform from happening?

[June7]

Can't - this is normal behavior. Why do you need the rows to remain selected?

[smbrush]

Selection and display of records from other tables are added to list boxes. The values in the selected subform rows are also displayed. I'm concerned that the user will become confused to see his/her row selection disappear after the list boxes are populated.

[June7]

Could probably apply some code that filters the subform to the selected records, otherwise users will have to learn.