Filter Form first record displayed

  • Thread starter Thread starter Leonard
  • Start date Start date
L

Leonard

Hi

Why is it when you filter a form and no records match, does the form still
display the first record in the table.

I'm using the DoCmd.applyFilter, in vba

How do you work around this?

Leonard
 
Why is it when you filter a form and no records match, does the form still
display the first record in the table.
Click to expand...

It shouldn't.
I'm using the DoCmd.applyFilter, in vba
Click to expand...

Post your exact usage. It's possible that your syntax is not quite correct.
 
Leonard said:
Hi

Why is it when you filter a form and no records match, does the form still
display the first record in the table.

I'm using the DoCmd.applyFilter, in vba
Click to expand...

It shouldn't. In a form that allows new records applying a filter with no
matches should display the empty new record position. If the form does not
allow new records to be added the form should go completely blank (at least
the detail section).
 
Thanks Bruce and Rick

After your comments I went back and rechecked my code and found where I had
gone wrong.

When I posted my question, I didn't know the effect of the junction table
and the impact on the filter, so after reading your replies I was able to
get it right.

Thanks


Leonard
 
Back
Top