Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    126

    Unanswered: Change Table Field Name Error

    I had a text field in a table called Status that was no longer used. I wanted to change it to a checkbox field called StatusInactive. I changed the field type and the field name in table design. After making sure there were no longer residual references to the old name in any queries or modules, I added the new name to the required queries and added the checkbox to the existing form. Now when I open the form (2-line macro open and gotorecord) I get a request to enter a table.old-fieldname value. My search through the documentor has been unable to find any remaining existance of old-fieldname.
    What have I missed?
    Pete
    PGT

  2. #2
    Join Date
    Aug 2006
    Posts
    126
    I should mention, I'm in MS Access 2003
    PGT

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •