I need some help with this problem.

In the past, before the split form of Access 2007, it was no problem to filter a combobox rowsource dependent on another control's value using the other control's after_update event and the form's oncurrent event.

When using a split form, the datasheet column for the combobox value is also filtered. This leaves the datasheet with a multitude of rows with blank values (not in the current column's filter) in the associated combobox's column.

The split form is a great feature but when one of the vital values used to select a row from the datasheet to edit in the form has blank values it is a problem.

I have tried many ways to try and retain the values in the split form's datasheet but as soon as the filter is applied to the combobox on the form, and the current record is committed, the datasheet column for the associated combobox has blank values if they are not in the current record's filter for the combobox.



The people that I am doing this for love the split form so I have to use it.
Does anyone know how to get around this problem?

Thanks
Walter Parker