access courses - Forms

Philip

Forms can only have one control source at a time. So if you do not have a field showing in the field list, you need to close the form, and add the field to the table or query that the control source is pointing to.

When you add a field to a form from a field list (control source), then the form and the underlying source are bound together. You can create fields that are unbound, however, there will be no link to the underlying source.

Richard

Philip,

To add a field to the field list, it must be present in the underlying table or query that the form links to.

To change the control source of a form, go to the deisgn view and view the properties of the form. This is found by double clicking the top lefthand conrner (you will see a square, double click on it) of the form design window.
One of the properties is control source, which you can cange there.

Richard