Results 1 to 9 of 9
  1. #1
    rexb is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    11

    How to display data from one form to another

    Hi,

    Can somebody show me how to display data's from one form to another.

    What I would like to do is when a user clicks a button he will be brought to a 2nd form and in that 2nd form are information (not all) from the 1st form. The 1st form is in a tab page and the 2nd is just a form on its own with master and child link.



    Thanks in advance.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    See if this link helps some.

  3. #3
    rexb is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    11
    I tried it but it gives me a compile error message

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    How about posting what you put in. There could easily be a typo somewhere.

  5. #5
    rexb is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    11
    should i just send you the database I'm working on?

  6. #6
    rexb is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    11
    Hello,

    I've attached my database. thank you in advance

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Your CommandButton was on the MainForm but the referenced TextBox was on a SubForm. Try this one.

  8. #8
    rexb is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2009
    Posts
    11
    Quote Originally Posted by RuralGuy View Post
    Your CommandButton was on the MainForm but the referenced TextBox was on a SubForm. Try this one.
    Thank you so much RuralGuy. Those are the things that I don't really know off. Please bear with me cause for sure I will continue posting if I find stumbling blocks on my way to developing this database.

    Again thank you.

  9. #9
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad I could help.

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

Similar Threads

  1. Display Non Matching Data
    By k1fox in forum Access
    Replies: 1
    Last Post: 04-03-2009, 07:18 PM
  2. Replies: 6
    Last Post: 02-20-2009, 11:50 AM
  3. Replies: 3
    Last Post: 10-23-2008, 08:43 AM
  4. How to display data from another record
    By rodrigo in forum Access
    Replies: 1
    Last Post: 07-24-2006, 07:29 PM
  5. Replies: 1
    Last Post: 03-02-2006, 06:17 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