How do I change the record source in Access?

Question

Method 1: Click the Build button In the Navigation Pane, right-click the report you want to modify, and then click Layout View. Right-click anywhere on the report, and then click Report Properties. On the All tab, click in the Record Source property box, and then click the Build button .

How do I change the data source in an Access database?

Edit a data source1Select External Data > Linked Table Manager. ... 2In the Linked Table Manager dialog box, select the data source, hover over the data source, and then select Edit.3Change the information in the Edit Link dialog box. ... 4Select Finish.

How do I change the Row Source property in access?

Click on the button (with the three dots) to the right of the Row Source property. A Show Table window will appear. Highlight the table that you wish to use in your query and then click on the Add button. Then click on the Close button.

What is the control source in access?

The Control Source is the field in a table your combo box is linked to, it could also be a query or an SQL statement. Either way it will display the data in that field and any updates you make to the combo box will be reflected in that field (unless it's a non-update-able query).

Expert · Answer