Results 1 to 4 of 4
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Form fields won't update (XP)

    I built a form on a query. The fields display the data perfectly, but they won't let me change the data. This form displays data from a catalog of items donated to a charity auction. I have fields for CatalogID (primary key), ProgramID (a manually assigned number), the item name, minimum acceptable bid, and minimum bid increments ($2, $5, $10 or whatever). When I created the form, I set some field properties to Enabled: No, Locked: Yes. This forced the form to go directly to the two fields I need to update (the bid fields).

    When I went to Form View, I could tab between the two enabled fields, but I could not change the data! The cursor shows up, and the form highlights the fields on enter, but no can change the values. I made sure the properties are set correctly. There's another similar form in this application that I'd built a few weeks ago which displays almost the same data, and it will let me modify the values. I tried enabling all the other fields in the form, but that changed nothing. What's going on here?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form fields won't update (XP)

    Can you edit existing records and add new records directly in the query?

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Form fields won't update (XP)

    It is possible the query behind the form is non-updatable. When you try to enter a value in one of those fields, is there any message in the Access Status Bar at the bottom of the screen?

    It is also possible you have set some of the form properties incorrectly. Make sure AllowEdits is "True", etc. And are you sure you set the Locked property on those fields in question to "False"?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Form fields won't update (XP)

    Hans and Mark: I can only apologize for not responding sooner. I was working on this particular form and query in much haste, and it appears that, in my haste, I inadvertently dumped both those items! <img src=/S/blush.gif border=0 alt=blush width=15 height=15> The whole question is pretty much "overcome by events," and I stumbled onto a solution somewhere along the way. Again, thanks for your unfailing support!

Posting Permissions

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