MS Access 2010 - Add new column RRS feed

  • Question

  • Hi,

    I'm working on ms access -2010 32 bit version of MS Access, SQL 2014 ( its a legacy application )

    I need to add a new column to an already existing subform, which I was able to do successfully but when I try to save data it doesn't save the data and neither does it throw any error in the newly added field.

    What's the usual steps or practice to do so (Sorry. learning my way to MS access)

    Thanks for the help!

    Monday, August 19, 2019 2:55 PM

All replies

  • Hi. Where did the new column you added to the subform come from? Did you add a new column to the table in SQL Server? If so, did you refresh the link to that table in Access?
    Monday, August 19, 2019 3:02 PM
  • Yes

    Step 1: I added the new column to SQL server database table and to the subform

    Step 2: I refreshed the the link.

    Step 3: On refreshing the link I could see the newly added column in the link table.

    Issue lies when I update the Form it doesn't write/update back to SQL database

    If I open up the link table in msaccess and update the value there it updates the database but If I update the form it doesn't update SQL database.

    • Edited by StSingh Monday, August 19, 2019 3:24 PM
    Monday, August 19, 2019 3:13 PM
  • And you only can't update the new column? You have no problems updating the other/previous ones on the subform, correct? If so, check the properties of the new control. You might also try adding a new one, just in case it got corrupted.
    Monday, August 19, 2019 4:22 PM
  • Exactly - I'm not able to update the new column but the old column works just fine...

    Day 2 Not sure how to get around this :(

    I tried deleting the newly added column and recreating but still the same issue.. it looks like I'm missing some step :(

    Any help clue is highly appreciated 

    Tuesday, August 20, 2019 12:39 PM
  • If the subform control's SourceObject property is not a table or query, is the ControlSource property of the relevant control in the subform the name of the new column?  Also, if the subform's RecordSource property is a query, does it include the new column?

    Ken Sheridan, Stafford, England

    Tuesday, August 20, 2019 5:45 PM