Results 1 to 4 of 4
  1. #1
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155

    Saving in table

    In the attached DB when I enter allocation the Dept. is automatically entered. But it is not saved in the table Tbl_ALLOCATIO-I. How to solve this problem?
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Haven't I given you explicit instructions in another thread on how to accomplish this?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155
    Quote Originally Posted by June7 View Post
    Haven't I given you explicit instructions in another thread on how to accomplish this?
    That site is closed for update.

    I am trying to update the table field in different events but without success. Please guide me. Updating the table field very important. I have attached the DB.
    Attached Files Attached Files

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Here is my advice:

    1. bind form to Tbl_Allocation-I, not query

    2. bind Dept textbox to Dept field not Dep

    3. combobox properties:
    RowSource: SELECT ALLOCA, DEP FROM ALLOCATION ORDER BY ALLOCA;
    ColumnCount: 2
    ColumnWidths: 1";0"
    AfterUpdateEvent: [Event Procedure]

    4. code
    Private Sub Combo32_AfterUpdate()
    Me.DEPT = Me.Combo32.Column(1)
    End Sub
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Saving Dates in a Table
    By bo16tx in forum Access
    Replies: 19
    Last Post: 12-29-2017, 09:27 PM
  2. Replies: 3
    Last Post: 04-22-2015, 04:35 AM
  3. Dlookup Value not saving in table
    By memento in forum Forms
    Replies: 9
    Last Post: 08-15-2014, 05:54 AM
  4. Combo Box not saving to table
    By dgriffin in forum Forms
    Replies: 11
    Last Post: 06-08-2011, 03:04 PM
  5. Saving to Table
    By Zerdan in forum Forms
    Replies: 2
    Last Post: 06-07-2011, 08:40 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