OFFXPDEV: Filter By Form Is Not Available in Run-Time Applications

Steps to Reproduce the Behavior

1. In the sample database Northwind.mdb, open the Customers form in Design view.
2. Add a command button to the form.
3. Change the Name property of the command button to btnFilter.
4. Set the OnClick property of the command button to the following event procedure:

   Private Sub btnFilter_Click()
     DoCmd.RunCommand acCmdFilterByForm
   End Sub
   					

5. Save the form, and then close it.
6. On the Tools menu, click Startup.
7. Under Display Form, click Customers in the list, and then click OK.
8. Click Start, click Run, and then type the following command in the Open box.
   
   NOTE: In the following sample, an underscore (_) at the end of a line is used as a line-continuation character. Remove the underscore from the end of the line when you type this command.
   
   NOTE: If Microsoft Office is not installed in the default location of C:\Program Files\Microsoft Office\Office10\, change the following path to where Msaccess.exe is located on your computer:
   "C:\Program Files\Microsoft Office\Office10\Msaccess.exe" _
   "C:\Program Files\Microsoft Office\Office10\Samples\Northwind.mdb" _
   /Runtime
9. When the Customers form opens, click the command button that you created in step 2.
   
   Note that the Filter-by-Form view does not appear and that you receive the error message mentioned in the "Symptoms" section of this article.

Back to the top