This dialog box defines a recordset as a source of dynamic content without you having to hand code SQL statements.
- In the Name text box, enter a name for the recordset.
A common practice is to add the prefix rs to recordset names to distinguish them from other object names in the code. For example:
Note that recordset names can only contain letters, numbers, and the underscore character (_). You cannot use special characters or spaces.
- Select a connection from the Connection pop-up menu.
If no connection appears in the list, click Define to create one.
- In the Table pop-up menu, select the database table that will provide data to the recordset.
The pop-up menu displays all tables in the specified database.
- To include only some of the tables columns in the recordset, click Selected and choose the desired columns by Control-clicking (Windows) or Command-clicking (Macintosh) them in the list.
- To include only some of the tables records, complete the Filter section as follows:
- From the first pop-up menu, select a column in the database table to compare against a test value you define.
- From the second pop-up menu, select a conditional expression to compare the selected value in each record against the test value.
- From the third pop-up menu, select Entered Value.
- In the text box, enter the test value.
If the specified value in a record meets your filtering condition, the record is includedthe recordset.
- If you want the records to be sorted, select a column to sort by, and then specify whether the records should be sorted in ascending order (1, 2, 3... or A, B, C...) or descending order.
- Click Test to connect to the database and create an instance of the data source.
A table appears displaying the returned data. Each row contains a record and each column represents a field in that record. Click OK to close the data source.
- Click OK.
The newly defined recordset appears in the Bindings panel.