Welcome to SPN

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

Sign Up Now!

Refreashing a feild list in Access

Discussion in 'Information Technology' started by sonfitz, Oct 28, 2005.

  1. sonfitz

    sonfitz
    Expand Collapse
    Guest

    If you make an addtion to a table and go to the form that is connected with
    that table to add the newly created feild how do you refreash the feild list
    so that you can see the new feild you added to the table that the form is
    connected to?
     
  2. Ofer

    Ofer
    Expand Collapse
    Guest

    Try

    Me.ListName.Requery
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benifit from it.

    Good luck



    "sonfitz" wrote:

    > If you make an addtion to a table and go to the form that is connected with
    > that table to add the newly created feild how do you refreash the feild list
    > so that you can see the new feild you added to the table that the form is
    > connected to?
    >
     
  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    If the RecordSource of the Form is the Table itself, the Field List will be
    automatically refreshed when you open the Form in DesignView.

    Since you asked the question, it is likely that the RecordSource of the Form
    is base in a Query / SQL String which is, in turn, base on the Table. In
    this case, you need to modify the Query / SQL to include the additional
    Field so that the Form can pick up the new Field.

    --
    HTH
    Van T. Dinh
    MVP (Access)



    "sonfitz" <sonfitz@discussions.microsoft.com> wrote in message
    news:29CE4245-864F-45E8-B221-FA683CDE05D2@microsoft.com...
    > If you make an addtion to a table and go to the form that is connected
    > with
    > that table to add the newly created feild how do you refreash the feild
    > list
    > so that you can see the new feild you added to the table that the form is
    > connected to?
    >
     
  4. sonfitz

    sonfitz
    Expand Collapse
    Guest

    Thank you, I feel like an idiot you were exactly right. Thanks again!

    "Van T. Dinh" wrote:

    > If the RecordSource of the Form is the Table itself, the Field List will be
    > automatically refreshed when you open the Form in DesignView.
    >
    > Since you asked the question, it is likely that the RecordSource of the Form
    > is base in a Query / SQL String which is, in turn, base on the Table. In
    > this case, you need to modify the Query / SQL to include the additional
    > Field so that the Form can pick up the new Field.
    >
    > --
    > HTH
    > Van T. Dinh
    > MVP (Access)
    >
    >
    >
    > "sonfitz" <sonfitz@discussions.microsoft.com> wrote in message
    > news:29CE4245-864F-45E8-B221-FA683CDE05D2@microsoft.com...
    > > If you make an addtion to a table and go to the form that is connected
    > > with
    > > that table to add the newly created feild how do you refreash the feild
    > > list
    > > so that you can see the new feild you added to the table that the form is
    > > connected to?
    > >

    >
    >
    >
     
  5. justin

    justin
    Expand Collapse
    Guest

    "sonfitz" wrote:

    > Thank you, I feel like an idiot


    Oh you're not an idiot. It took me forever to figure that out too.


    --
    I''m not an MVP.

    Combien de bois est-ce qu''une marmotte d''Amérique jetterait si une
    marmotte d''Amérique pourrait jeter le bois ?
     

Share This Page