Results 1 to 2 of 2
  1. #1
    Rudolf14 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    5

    Adding data to a field

    HI all,



    First of all, I'm new to ms access.

    I'm busy creating a report writer data base for my work. Currently I have a problem and need help...

    my database is as follows;

    Tables:
    TblArea: list of areas for reporting.
    TblMachine: list of machines currently in production
    TblDescription: a detailed description of the faults we identify ( I will come back this Tbl shortly)
    Tblmain: This table has the following data fields:
    Date: date field,
    Area: Tblarea(lookup),
    Machine: Tblmachine(Lookup)
    Description: TblDescription(Lookup).

    On the Description I can't add new descriptions once I'm in TblMain. I need to use the drop down menu for it.
    What do I do to enable it so I can either select from the drop down menu or add new descriptions?

    Attached I included the DB[ATTACH]

    Regards,
    Rudolf
    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
    53,770
    Main form and subform are both bound to tblMain which appears to emulate intrinsic split form design.

    Use combobox NotInList event to add new items on-the-fly. https://blueclawdatabase.com/notinlist-event-code/
    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. Adding Field to Form but Data Not Displaying
    By PATRICKPBME in forum Forms
    Replies: 3
    Last Post: 08-04-2017, 01:53 PM
  2. Replies: 14
    Last Post: 02-24-2017, 12:59 AM
  3. Replies: 3
    Last Post: 07-01-2016, 08:11 AM
  4. Replies: 3
    Last Post: 04-14-2013, 12:38 PM
  5. Replies: 2
    Last Post: 12-03-2010, 09:33 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