Table filter question

[John Sh]

I have a table filtered on a field, set to filter on form open.
When opening the form the records shown comply with the filter.
If I change the value of the filtered field I can still scroll to the altered record.
Is this normal behaviour for a filtered table or am I missing something?

 

[arnelgp]

Is this normal behaviour for a filtered table or am I missing something?

i think it is.
you hit the "Refresh button" (Ribbon->Home->Records->Refresh All) to filter it again after editing.

 

[John Sh]

i think it is.
you hit the "Refresh button" (Ribbon->Home->Records->Refresh All) to filter it again after editing.

Thanks again.

 

[John Sh]

i think it is.
you hit the "Refresh button" (Ribbon->Home->Records->Refresh All) to filter it again after editing.

I have found a "form.requery" in the form_afterupdate sub does the trick.
Thanks again for your input.

 

[arnelgp]

did you noticed that when you issue form.requery, you are tossed to the
first record in the table/query?

if you want to avoid that, use:

Me.Recordset.Requery

 

[John Sh]

did you noticed that when you issue form.requery, you are tossed to the
first record in the table/query?
.

Yes, and that's exactly how I wanted it and still with the ability to scroll through records.