Microsoft Office Tutorials and References
In Depth Information
Changing the data source for a form
Change the record source from a
table to SQL
7 Double-click the asterisk (*) in the table to select all fields (or select
a list of the desired fields).
8 To filter by a field, double-click the field to add the field to the
query grid, and then clear the Show check box below the field.
9 Click Close.
10 Click Yes to save your changes.