Filter by form

Resolved · Low Priority · Version 2003

Thu 10 Jul 2008, 15:56 Delegate Richard said...

Richard has attended:
Excel VBA Intro Intermediate course
Access VBA course

Filter by form

Please could you tell me how to filter datasheets by form

Mon 4 Aug 2008, 11:18 Trainer Stephen said...

RE: 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

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips

Filter by form

Filter by form

RE: Filter by form

Access articles

Access tip:

Hiding rows and columns