Results 1 to 6 of 6
  1. #1
    jenson is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Sep 2019
    Posts
    3

    Macro required to link through to another form with the associated record data

    Hi,



    I've got a macro set up so that when the button in a form (showing info about a record) is clicked, it takes the user through to another form where more information tied to that record is. The button works fine, but at the moment it is just showing a random record in the next form when clicked. I want it to be tied to the record that exists in the first form.

    Context:

    The table of data tied to the first form differs from the table tied to the second form, but they are linked.

    Hope that makes sense. In essence, I need record data to flow from one form to the next.

    Thanks in advance

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Tell us more about the data and the tables involved. Data is stored in tables. Forms are used to show the user some or all of the data in tables. What is it that relates one table to the other?

  3. #3
    jenson is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Sep 2019
    Posts
    3
    The data is essentially policy development. The table holds data about policy development for a particular stage, which I have displayed in a form. What I want to do next is show the next stage of development in a form for the policy(ies).

    To map it (and there's a search stage for this too)

    Search policy > returns data in form for first stage > button in the form to the next stage of policy development > form showing that particular policies development in that next stage.

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do you have a table (or some scheme) that identifies (at least conceptually)

    tblStageFlow
    -CurrentStage
    -PreviousStage
    -NextStage

    such that given a currentStage you can find the previous (or Start) and/or the next (or End).

    Can you post a jpg/png of your tables and relationships?

  5. #5
    jenson is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Sep 2019
    Posts
    3
    Sorted! Had to go away and think about it.

    It actually differs from what I had first asked.

    Solution was within the macro to reference a search field from my main form.

    Thank you for going through those steps though. I'm sure they'll be useful for other things I encounter.

    Cheers

  6. #6
    orange's Avatar
    orange is online now 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: 9
    Last Post: 11-14-2018, 01:32 PM
  2. Replies: 9
    Last Post: 03-01-2017, 10:00 AM
  3. Macro to mimic Import & Link Excel button on external data
    By arnstrb in forum Import/Export Data
    Replies: 1
    Last Post: 03-16-2014, 07:52 PM
  4. Replies: 4
    Last Post: 01-16-2013, 12:33 PM
  5. Replies: 1
    Last Post: 11-30-2012, 02:04 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