Results 1 to 4 of 4
  1. #1
    andwhy81 is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    11

    One Form, Multiple records

    Ive searched and haven't found a non-vba solution.



    I have one form that has a combo box with pilot names, there is a possibility of up to four flight codes (at least one). The manager requesting my database wants to be able to select multiple fly codes per pilot instead of a new entry for each one. These are entered by date and I am running a query that shows a pivot table with dates and codes sorted by pilot.

    let me know if there is a easy way to do this. I have seen sub forms but i don think that will work. thanks in advance

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Your dates and flight codes have a 1:m relationship with the pilots. That is usually displayed and edited using a MainForm/SubForm arrangement. What is wrong with that?

  3. #3
    andwhy81 is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    11
    I guess i'm still wrapping my head around subforms.. I havent been able to get one to do what i want, is there a way to display both on the same page?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Create a form and then let the wizard add your SubForm. It will assign the LinkChild/MastFields properties and usually gets it to work.

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

Similar Threads

  1. Replies: 15
    Last Post: 10-01-2015, 10:06 AM
  2. Add Multiple Records on One Form
    By William McKinley in forum Forms
    Replies: 7
    Last Post: 08-18-2010, 09:31 AM
  3. Replies: 47
    Last Post: 06-17-2010, 03:04 PM
  4. Create multiple records with 1 form?
    By bergjes in forum Forms
    Replies: 4
    Last Post: 04-14-2010, 06:16 AM
  5. Trying to create multiple records from a form
    By ed_hollywood in forum Forms
    Replies: 4
    Last Post: 04-02-2010, 10:57 PM

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