How do I get Microsoft Access to filter by form?

Answer by  justme2882 (61)

Open the program, then open your datasheet or table that you want to filter. On the toolbar, click on the "Filter by Form" option. This will open up a new window. You will need to select your criteria, select the value that you are searching for and click apply to give you the information you are looking to gain.

Answer by  WendyD (29)

Ok, simply go to the records menu, hover over the filter and then click filter by section, repeat until you get the required results click on a subdatasheet click the feild where you want to apply the crtiera, click filter and apply filter, this should then apply Microsoft Access filter to form.

Answer by  gigo (1706)

You have to add a VBA handler for the control in the form. In this handler you have to manipulate the WHERE clause of the SQL query.

Answer by  gigo (1706)

In the onclick event of the formular you have to write myform.Filter = "Fieldname = 77" and then myform.FilterOn = True.

Answer by  gigo (1706)

Over a control in the form you can generally filter by form. If the field you wish to filter on is not in the form, change the record source of the main form to an SQL statement with an INNER JOIN to the table which contains the field you wish to filter on.