Results 1 to 2 of 2
  1. #1
    dgamma3 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2012
    Posts
    2

    display/add new info on a form


    Hi. My current database is in need of an upgrade. Currently (view image), as you can see (its the only form), each student entered into the database can only have one course.

    However, I would like to add the ability for students to have multiple courses. my problem isn't so much how does the database user enter in the new course for the student. This can be achieved with another form. However, I am struggling on how I would display these multiple course, in a user friendly way, on a form. What controls do i use? I'm thinking a table control would be suitable (much like an excel spreadsheet) as it would allow show all the courses/ edit a specifc field if required. However i do no believe access 2010 has this control.

    thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    Use form/subform arrangement. The controls for Course Details would be on subform synchronized to the main form that has the student info.

    What is the data structure (tables and relationships)?

    Why would you want to allow deleting student records?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 3
    Last Post: 01-17-2012, 01:04 PM
  2. Replies: 35
    Last Post: 12-21-2011, 02:16 PM
  3. Replies: 9
    Last Post: 02-15-2011, 03:05 PM
  4. Replies: 3
    Last Post: 01-31-2011, 11:47 AM
  5. Replies: 13
    Last Post: 06-01-2010, 09:55 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