Results 1 to 3 of 3
  1. #1
    nono5551212 is offline Novice
    Windows 8 Access 2013
    Join Date
    Jun 2014
    Posts
    11

    Click 1 form to load data on another form

    I was hoping someone could show me how to load a record on a form..

    I only have one table that both forms pull from.

    I have 3 forms. The only form a user will ever see is F_Main



    F_MAIN (Just loads the 2 forms below within itself)
    F_Data_Short (Grid View.. Rows and Columns.. All Records.. Shows some fields)
    F_Data_Long (Single Record View.. Showing all fields)

    F_MAIN
    -> On the left is F_DATA_SHORT
    -> On the Right is F_DATA_LONG

    How can I set it.. When a record on the left included form is clicked.. it loads that same record on the right included form. No pop ups...

    I know I can use the On Click option for the form on the Left... and set code or a macro to the load the data on the right. I tried everything and can't seem to get the data to load on the right when a record is clicked on the left...

    Thanks for taking the time to read my post.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Data is not stored in forms. Data is stored in tables. You only have one table. Use bound controls in the first form to populate fields in your tale. Use bound controls on another form to display the data stored in the table. Use the .Requery Method of your form(s) to "see" the most current data in the table.

  3. #3
    nono5551212 is offline Novice
    Windows 8 Access 2013
    Join Date
    Jun 2014
    Posts
    11
    I figured it out.

    MACRO
    BROWSETO
    Object Type: Form
    Object Name: Your_Form
    Path to Subform Control: Your_Main_Form.Your_Form
    Where Condition: =="[ID]=" & [ID]
    Page:
    Data Mode: Edit

    Also you should prefix the Macro
    If IsNull([ID]) Then
    Stop Macro
    End If

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

Similar Threads

  1. Replies: 1
    Last Post: 02-18-2014, 02:16 PM
  2. Replies: 4
    Last Post: 06-10-2013, 08:01 AM
  3. Replies: 1
    Last Post: 08-24-2012, 06:50 AM
  4. Replies: 3
    Last Post: 11-29-2011, 07:01 AM
  5. Form - Filter on load (if data exists)
    By dilbert in forum Forms
    Replies: 0
    Last Post: 08-13-2010, 11:39 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