Welcome to SPN

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

Sign Up Now!

Can't change table data from a form

Discussion in 'Information Technology' started by Kelly Wilbur, Nov 3, 2005.

  1. Kelly Wilbur

    Kelly Wilbur
    Expand Collapse
    Guest

    I have created a very simple form that pulls information from a number of
    tables (the form is built on tables, not queries). I try to update my
    information while I am in a form, but the form doesn't allow me to type in
    any fields or change any values in any fields. However, I can change the
    values if I go straight to the table.

    How can I set this up to be able to use the form to update data in the tables?

    I was once told (perhaps incorrectly) that I needed to have the form built
    from queries which were built from tables in order to be able to update from
    a form. However, I tried this and had the same problem.

    Please help.

    Thanks,

    Kelly
     
  2. Loading...


  3. Ofer

    Ofer
    Expand Collapse
    Guest

    Most chances are, whe you link few tables together you won't be allow to
    update them, you can update each oe seperatly, but when you join them
    together you can't.

    In the form, you can try and split the tables to seperate sub forms ,that
    each one of them based on another table.

    Try and update the query or the sql that the form is based on, if you can,
    then check the can edit ptoperty of the form if it set to yes
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benefit from it.

    Good luck



    "Kelly Wilbur" wrote:

    > I have created a very simple form that pulls information from a number of
    > tables (the form is built on tables, not queries). I try to update my
    > information while I am in a form, but the form doesn't allow me to type in
    > any fields or change any values in any fields. However, I can change the
    > values if I go straight to the table.
    >
    > How can I set this up to be able to use the form to update data in the tables?
    >
    > I was once told (perhaps incorrectly) that I needed to have the form built
    > from queries which were built from tables in order to be able to update from
    > a form. However, I tried this and had the same problem.
    >
    > Please help.
    >
    > Thanks,
    >
    > Kelly
     

Share This Page