Results 1 to 2 of 2
  1. #1
    joecamel9166 is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    85

    Changing data already stored in table

    In the code I have, Everything works fine from blank fields in the record. IF I enter information and make a mistake, and have to change the disposition, I need to update the Est_hours and Est_Materials field values back to "0".
    Here is the code.
    As of now, If I have 3 hours in the Est_hours field and then change the disposition from None to SFR, the Est_Hours field value stays at 3.


    Code:
    If Me.cmbDisposition = "SFR" Then Me.Unit_Status = "S" Me.Est_Hours.Value = "0" Me.Est_Materials.Value = "0" DoCmd.OpenForm "frmHours", acNormal Else End If

  2. #2
    joecamel9166 is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2016
    Posts
    85
    I feel dumb, I changed it to a different sub and it works fine.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 07-16-2015, 12:02 AM
  2. Replies: 0
    Last Post: 12-03-2014, 11:53 AM
  3. Changing ODBC Linked Table Stored Credentials
    By JeffGeorge in forum Access
    Replies: 1
    Last Post: 08-09-2013, 01:53 PM
  4. Replies: 2
    Last Post: 12-17-2012, 03:46 PM
  5. Replies: 1
    Last Post: 11-15-2012, 09:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums