How do I change the data source of a control?

How do I change the data source in Access?

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 you add a control source?

TO CHANGE A CONTROL'S DATA SOURCE: RIGHT-CLICK THE CONTROL AND SELECT PROPERTIES FROM THE SHORTCUT MENU. SELECT THE CONTROL AND SELECT VIEW » PROPERTIES FROM THE MENU. CLICK THE DATA TAB. CLICK THE CONTROL SOURCE BOX, CLICK THE ARROW, AND SELECT THE FIELD THAT YOU WANT TO BIND THE CONTROL TO.

What is control source access?

You can use the ControlSource property to specify what data appears in a control. You can display and edit data bound to a field in a table, query, or SQL statement. You can also display the result of an expression. Read/write String. expressio n.ControlSource.

How do I edit a database in Access?

1Step 1: Change the main data connection in the form template. On the Tools menu, click Convert Main Data Source. ... 2Step 2: Select the database tables. In the Select Table dialog box, click the name of the primary table or query, and then click OK. ... 3Step 3: Preview, publish, and test the form template.