Results 1 to 2 of 2

Insert records into a secondary table using data from a primary table

  1. #1
    scottk is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Nov 2018

    Question Insert records into a secondary table using data from a primary table


    I am trying to build a database which has a checklist type functionality. I have created forms & subforms to present the information as I want it. My only problem is getting my macro to work correctly when inserting a new record into my primary table. The macro is Create a Record in the secondary table. The first SetField is supposed to pull a value from a field in the primary table. The other SetField statements are inserting static text data into fields in the secondary table.

    I have followed the instructions by @JeffConrad in this thread on the microsoft forum:

    When I set it up the way he has, I still get an error for the SetField pulling info from the primary table:

    The identifier '[Deal Profile].[Deal Name] could not be found. This is indeed the table and field name and I even used intellisence to ensure I pulled it correctly. I am not sure what I am doing wrong or how to fix it. I hope someone can help.

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    Suggest you post pics of your macro. No promises because most of the responders I know here (including me) don't use macros. By any chance is the data coming from a form or subform? If a subform, I suspect your form reference isn't valid - and if a navigation form is involved, that's even worse.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    Code isn't smart. It does what you ask with what you give it.

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

Similar Threads

  1. Replies: 5
    Last Post: 12-01-2014, 10:31 AM
  2. Replies: 3
    Last Post: 04-09-2014, 11:48 AM
  3. Replies: 2
    Last Post: 12-20-2011, 06:33 AM
  4. Replies: 1
    Last Post: 12-28-2010, 10:24 AM
  5. Replies: 0
    Last Post: 02-23-2010, 11:56 PM

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
Tech Forums: Microsoft Office Forums