Filter on subform - subform not updating.

  • Thread starter Thread starter s_coulson
  • Start date Start date
S

s_coulson

Hi,
I am applying a filter to a subform by setting its filter and filterOn
properties. The filter is dynamic and changes depending on a user
selection from a control on the form.

On opening my form I use the control to change the filter, but the
subform does not update and still shows the full data set. Strangely,
if I iterate through the sub form's recordset it appears to be
correctly filtered. Even more strangely if I perform an action that
leads to an Access error message, from then on the subform behaves as
expected and updates.

Has anyone had similar experiences to this? All I want to do is have a
correctly working filter on my subform.

Thanks,
Simon
 
Back
Top