Philip has attended:
Access Introduction course
Forms
How do i insert a new field in a form when that field does not appear in the field list? Alternatively, how do I change the control source of an existing field to one which doesn't appeaar in the control source list?
RE: 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
RE: Forms
When I have added the field to on of the tables my form is pointing to, it still doesn't appear on the field list. Is there a 'update field list' function or something? Because if that should happen when you open and close the form it isn't doing so!
RE: Forms
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
