Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    First record in file updated when new rec added (XP)

    I have an issue when adding new invoices into a master file. The record gets added correctly, but the first record gets updated as well. The account number disappears, and the billing date gets updated with the value of the record just entered. Are there any suggestions as to why this erratic behavior is occuring???

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: First record in file updated when new rec added (XP)

    We will need to know the details of how you are adding the invoice record to be able to provide much help. Is this being done from a bound form or an unbound form? What kind of code is running when you add a record? What is the primary key of your master file? Any thing you can think of as suspect would also be useful.
    Wendell

  3. #3
    Star Lounger
    Join Date
    Aug 2002
    Location
    Des Moines, Iowa, USA
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: First record in file updated when new rec added (XP)

    Wendell, you hit on something I hadn't checked. I am attempting to run with a bound form. When I unbound it (by using input masks and formats to ensure that the correct type of data was being entered, and that it didn't exceed size limitations,etc), the add procedure behaved as it was supposed to.

    I am pretty new to the Access programming bit (being only my third attempt overall, and my first using bound forms), so I'll have to study the whole binding subject before attempting it again. Thank you for your response. I hadn't thought of the form being bound as being suspect.

Posting Permissions

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