I have a main form in form-view with a subform in datasheet-view. The subform shows data related to the main form.
The subform has two combobox columns and two textbox columns.
When I select another record in the main form the data in the subform is updated correctly, everything is OK.
If I apply filtering in the main form, the combobox columns in subform are not updated, they turn blank.
This is an error. I apply filtering the following way: I right-click on a number field in the main form, select “Number filters -> Equals” and fill in a number to go to a specific record.
Filtering in the main form seems to do something with the comboboxes in the subform.
The form and the subform are linked with Link Master/Child fields.
I have tried Combobox.requery on subform current event without success.
What could be wrong here?
Regards