Adding a new field to a control source on a form

[Anne Saunders]

I have added a new field to a table and want to put this as a control source on a form. However, when I try to select this new field from the properties of the control source its not showing up on the field list. How do I update the field list to include this new field?

 

[scottfarcus]

Most likely the source for the form is a SQL statement, not a table. Go to the properties dialog box for the form. The first available field will be Record Source. Click the build button (...) next to this field. This should open a query window. Find the table that has the new field. Drag the new field down into the query grid. Close the query window and save the changes to the SQL statement.

Either the record source is a SQL statement or the record source is a query. Either way, you should be able to add your field using the steps above.

Good luck!

 

[Anne Saunders]

Thank you Scott! worked a treat.