Results 1 to 4 of 4
  1. #1
    lccrews is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Location
    Los Angeles
    Posts
    194

    Can you automate addition of a new record?


    I have a form that allows additions of 'raw materials' to added to tbl_formulas. However, Access stops me because there's a one-to-many relationship that prevents items not on tbl_rawmaterial from being added. I'd like Access to automatically add what's entered in [Raw Material] on this form, to tbl_rawmaterial if the item doesn't exist. Is that possible?

    To be more specific,
    If entry made to Forms!frm_CurrentFormula![Raw Material] does not exist in tbl_RawMaterial.[Raw Material], add it.

  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
    Are you doing entry of [Raw Material] via a combobox? Enter a new raw material 'on-the-fly' with the combobox NotInList event. This is a common topic. Search forum or web. Review http://www.blueclaw-db.com/access_no...ed_example.htm
    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
    lccrews is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Aug 2017
    Location
    Los Angeles
    Posts
    194
    Thanks June7. That's what I needed.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

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

Similar Threads

  1. Replies: 2
    Last Post: 04-24-2016, 03:10 PM
  2. Replies: 3
    Last Post: 10-14-2015, 07:24 AM
  3. Replies: 3
    Last Post: 05-03-2015, 10:28 AM
  4. Querry to automate previous record HELP!
    By rajgoyal00 in forum Queries
    Replies: 9
    Last Post: 12-15-2011, 03:17 PM
  5. Automate record entry on Subform
    By Davetartblog in forum Forms
    Replies: 7
    Last Post: 10-04-2011, 02:23 AM

Tags for this Thread

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