Welcome to SPN

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

Sign Up Now!

changes in Table Design don't take in Form View

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

  1. Rich D

    Rich D
    Expand Collapse
    Guest

    I make a change to a field in Table Design (for example, create a drop down
    box where there was none). I then close that window, open Forms View to
    enter data, and the change to that field has not taken place. What am I
    doing wrong?
    --
    Rich D
    Armstrong Custom Homes
    Redmond
     
  2. Loading...

    Similar Threads Forum Date
    Angry exchanges with Christians Blogs Oct 17, 2015
    Day 1-Forever Changes, Love Blogs Oct 17, 2015
    Travel Jet-lag Study Reveals Why Time Changes Are A Struggle Breaking News Sep 11, 2013
    General Should Religion Be Altered with Changes in Time and Society? Hard Talk Apr 15, 2013
    India The Giani And The Sea Of Changes Breaking News Jun 3, 2012

  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Rich D wrote:
    > I make a change to a field in Table Design (for example, create a
    > drop down box where there was none). I then close that window, open
    > Forms View to enter data, and the change to that field has not taken
    > place. What am I doing wrong?


    Expecting that to happen. The only design aspect of the form that cares one bit
    about the design of the table is the presence or absence of fields and their
    DataTypes.

    Most of the "inheritance" from tables that you see in forms is provided by the
    form wizards when the form is first created. After this most changes have to be
    done in both places separately.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. c02homer@hotmail.com

    c02homer@hotmail.com
    Expand Collapse
    Guest

    You have to refresh the field in your form. This can be accomplished
    one of two ways: 1) in your form, delete the field and reinsert it; or
    2) go into the field's properties, change the Control Source to a
    different field and click out of it, then change the field back to the
    original field, which refreshes the field.

    I hope this helps!


    Rich D wrote:
    > I make a change to a field in Table Design (for example, create a drop down
    > box where there was none). I then close that window, open Forms View to
    > enter data, and the change to that field has not taken place. What am I
    > doing wrong?
    > --
    > Rich D
    > Armstrong Custom Homes
    > Redmond
     
  5. c02homer@hotmail.com

    c02homer@hotmail.com
    Expand Collapse
    Guest

    You have to refresh the field in your form. This can be accomplished
    one of two ways: 1) in your form, delete the field and reinsert it; or
    2) go into the field's properties, change the Control Source to a
    different field and click out of it, then change the field back to the
    original field, which refreshes the field.

    I hope this helps!


    Rich D wrote:
    > I make a change to a field in Table Design (for example, create a drop down
    > box where there was none). I then close that window, open Forms View to
    > enter data, and the change to that field has not taken place. What am I
    > doing wrong?
    > --
    > Rich D
    > Armstrong Custom Homes
    > Redmond
     
  6. Rich D

    Rich D
    Expand Collapse
    Guest

    Thanks to both of you. I'm glad to find I'm not nuts.
    --
    Rich D
    Armstrong Custom Homes
    Redmond


    "Rick Brandt" wrote:

    > Rich D wrote:
    > > I make a change to a field in Table Design (for example, create a
    > > drop down box where there was none). I then close that window, open
    > > Forms View to enter data, and the change to that field has not taken
    > > place. What am I doing wrong?

    >
    > Expecting that to happen. The only design aspect of the form that cares one bit
    > about the design of the table is the presence or absence of fields and their
    > DataTypes.
    >
    > Most of the "inheritance" from tables that you see in forms is provided by the
    > form wizards when the form is first created. After this most changes have to be
    > done in both places separately.
    >
    > --
    > Rick Brandt, Microsoft Access MVP
    > Email (as appropriate) to...
    > RBrandt at Hunter dot com
    >
    >
    >
     

Share This Page