Filter by form

Hi Richard

Thank you for your question.

First let me apologise for the delay in responding to your post, this was due to very high volumes of posts on the forum.

The easiest way to filter the data on a form is to set the form's control source to an SQL Query. For example

Me.ControlSource = "SELECT * FROM Employees WHERE Title = "Sales Representative;"

This would affectively filter the form so that it was only showing employees who are sales representative

Hope this is useful

Regards

Stephen