Results 1 to 5 of 5
  1. #1
    JessicaNicole is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Washington
    Posts
    8

    Tables/Sub-Tables into Forms

    I have a table along with a sub-table. I've made a data entry form for the main table, and I am wanting to add a command button on that form which would open the related form(from the sub-table). I made the button and put code behind it but can't seem to figure out what will work. I used "[ID]=" Me![ID] but since it is a data entry form I realized that it wouldn't work since there wouldn't be any related information to open. I just want to make sure my ID's are the same when they are filling out either form. Any suggestions?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    Does this apply?
    http://www.mvps.org/access/lookupfields.htm
    If not can you show us your table designs?

  3. #3
    JessicaNicole is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Washington
    Posts
    8
    Hopefully this link works.

    This is what my forms look like. frmNewGrower is from the main table and would populate all those fields. frmNewLot is the subtable and would need to populate based on whether the ID is the same.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    Do you have lookups at the table level?

  5. #5
    JessicaNicole is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Washington
    Posts
    8
    No. I attached the picture of the table design and datasheet.

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

Similar Threads

  1. Replies: 10
    Last Post: 07-12-2011, 11:09 PM
  2. forms and tables
    By Roberta in forum Access
    Replies: 2
    Last Post: 09-02-2010, 02:48 AM
  3. Forms and tables
    By phoenix in forum Access
    Replies: 1
    Last Post: 03-03-2010, 04:52 PM
  4. Forms and Tables
    By Nixx1401 in forum Access
    Replies: 7
    Last Post: 03-02-2010, 11:51 AM
  5. update tables via forms
    By jazoo in forum Forms
    Replies: 0
    Last Post: 09-16-2008, 05:54 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