Results 1 to 4 of 4
  1. #1
    shiphtfour is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Dec 2010
    Posts
    36

    How to use a subform to select and use records


    I have built a form for entering offspring into a database for a laboratory that breeds mice. I know very little about access however, trying to learn as I go along, but I need help with setting up how this form updates or adds records to the various tables associated with it.

    I'm trying to use a subform to select the parents of the offspring from a query. So my question is, how do I pull the MouseID records from the parent cage selected and use them to associate the offspring with their parents in a MiceRelations table. Here is what the form looks like to give you a better idea:


  2. #2
    shiphtfour is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Dec 2010
    Posts
    36
    Is it not possible to select records from a subform and use them with the records entered from the main form?

  3. #3
    shiphtfour is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Dec 2010
    Posts
    36
    I really have no idea how to do this, can anyone point me in the right direction?

  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
    This link *may*, I say *may* help: http://allenbrowne.com/ser-06.html

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

Similar Threads

  1. Replies: 0
    Last Post: 10-12-2010, 06:08 AM
  2. Replies: 2
    Last Post: 03-25-2010, 12:11 PM
  3. Use one subform as a select list
    By larryb43 in forum Forms
    Replies: 0
    Last Post: 02-27-2010, 03:08 PM
  4. select records in recordset
    By sksriharsha in forum Programming
    Replies: 3
    Last Post: 09-05-2009, 11:40 AM
  5. Replies: 1
    Last Post: 03-01-2009, 09:53 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