Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to automatically update form after changing table?

Discussion in 'Information Technology' started by carvelln, Jul 28, 2006.

  1. carvelln

    carvelln
    Expand Collapse
    Guest

    Hi there

    Is there a way to automatically update a form after I have changed the table
    the form was based on (e.g., adding or deleting a field).

    I know how to manually add or delete afield in the design view for forms.
    Just wanted to see if there is an easier way.

    Thanks!
     
  2. Loading...


  3. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    No you would need to open the form in design view and make changes. The
    table that the form is based on has no relationship to the actual form design
    just the data that the form displays.

    To delete a field simply open the form in design view select the field and
    press delete then save (make SURE you want to do this before you save ??)

    Hope this helps



    "carvelln" wrote:

    > Hi there
    >
    > Is there a way to automatically update a form after I have changed the table
    > the form was based on (e.g., adding or deleting a field).
    >
    > I know how to manually add or delete afield in the design view for forms.
    > Just wanted to see if there is an easier way.
    >
    > Thanks!
     
  4. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    Just had a thought is you delete that field in the base table thenthe field
    will be still be on the form but as an unbound field box (you will still need
    to delete it)
     

Share This Page