Results 1 to 2 of 2
  1. #1
    rmoore is offline Advanced Beginner
    Windows XP Access 2016
    Join Date
    Feb 2020
    Posts
    47

    Opening new form with macro that auto populates

    Hello everyone, I need a little help with something. I have a Customer form with a Tab control that has 2 pages (Workorders and Assets). On the Assets page, I have a Subform in datasheet view showing all the Assets for that customer. I have a Dblclk Macro to open a new "WorkOrder form" when I double click on the asset name. I cant figure out how to auto populate the new form with the asset details. I would like to open a new workorder from the list of assets and have the asset info auto populate.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,925
    You could pass in the AssetID in OpenArgs, and test for it in the opened form.
    You could set a TempVar in the calling form and read that in the open form.

    That is at least two ways.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 7
    Last Post: 07-29-2018, 11:58 AM
  2. drop down that auto populates row
    By Onyx in forum Access
    Replies: 4
    Last Post: 03-14-2018, 11:10 AM
  3. Search Box that auto-populates
    By LukeJ Innov in forum Forms
    Replies: 3
    Last Post: 07-18-2013, 03:02 AM
  4. Replies: 9
    Last Post: 02-04-2013, 03:22 PM
  5. Replies: 3
    Last Post: 11-09-2011, 03:43 PM

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