Results 1 to 6 of 6
  1. #1
    Exwarrior187 is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    13

    Tabbed SubForm Issues


    Greetings!

    I have a MainForm named North Florida. In this form is a Tab Control with 3 Tabs. Entry, Comments, and Projects (This tab has a Subform on it named Project Subform).

    The Entry and Comments Tabs are linked to a table named North Florida, the Projects Subform on Tab 3 is linked to a table named Projects.

    My North Florida table is linked to my Projects table with the relationship being in a field named ID.

    My issue is that I cant seem to return some common data points from the Entry Tab to the SubForm on the Projects tab. I need to record those field on the Projects Subform to the Projects table so I can't use DLookups to bring the values I want over. I've attempted to use BeforeUpdate events but to no avail. Perhaps I'm going about it all wrong which is why I've posted my issue here.

    Any help is appreciated!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    This link describes the syntax required: http://www.mvps.org/access/forms/frm0031.htm

  3. #3
    Exwarrior187 is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    13
    Thanks for the Link! I'm trying to use some of these syntaxes to get my desired results but i'm still falling short here.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What does "falling short" mean? Syntax error? Nothing happens? What?
    Show us one of the lines of code you are using.

  5. #5
    Exwarrior187 is offline Novice
    Windows XP Access 2003
    Join Date
    Jan 2011
    Posts
    13
    My BeforeUpdate Event was not working, so I tried using the below script in an OnEnter Event and it will suffice for the time being. Thanks for the link to the Syntax!

    Code:
     
    Me.ProjOneAgent = Me.Parent![Agent]

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    If your happy, we're happy.

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

Similar Threads

  1. Tabbed forms
    By jonesy29847 in forum Forms
    Replies: 5
    Last Post: 02-25-2011, 10:35 AM
  2. Tabbed Sub Form
    By Vikki in forum Access
    Replies: 1
    Last Post: 02-10-2010, 10:30 AM
  3. Subform and calculations issues
    By rustyCrVx in forum Access
    Replies: 1
    Last Post: 05-02-2009, 03:37 PM
  4. Replies: 0
    Last Post: 03-11-2009, 11:40 AM
  5. Subform Issues
    By dromorkid in forum Forms
    Replies: 0
    Last Post: 11-24-2008, 11:35 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