Results 1 to 2 of 2

Showing the results of an SQL query in a combo box to add records to a table.

  1. #1
    mrbaggins is offline Novice
    Windows 7 Access 2007
    Join Date
    Oct 2010
    Posts
    7

    Showing the results of an SQL query in a combo box to add records to a table.

    I've done this before, so I know it's possible, but can't for the life of me remember how I've done it.



    I have 3 tables:
    Student details
    Activities (contains name/date/location of activities)
    Registration (Which pairs ActivityID's with StudentID's)

    What I've done is make an Enter Activity Details form, which has details about an activity and the students doing it. This form has has the student details in a subform (Datasheet) with Student Name/Lastname/Gender.

    This lets me add students to activities by storing the relevant ID's in Registration.

    The nifty part was that each cell in the datasheet was a combo box, that when clicked pulled up every student sorted by whichever column you picked. So you could choose which way to sort the data when adding, depending on if you wanted to jump to lastnames/firstnames or whatever.

    It showed as a mini-datasheet, with ALL the columns in the popup though.

    Now I'm trying to do this again, pretty much identically, but with Awards.

    So I have the tables:
    Awards
    Student details
    AwardRegistration

    But no matter what I do, I only get one field turning up in the combobox popup. I've got the record source for each field being the SQL query identical to the Activities form, and I've been mucking around for ages, but can't get it to work the same way as Activities Entry does.

    What stupid little gimmick am I missing?

  2. #2
    mrbaggins is offline Novice
    Windows 7 Access 2007
    Join Date
    Oct 2010
    Posts
    7
    No one knows what I'm talking about? Would a screen shot help?

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

Similar Threads

  1. Query not showing all records
    By gazzieh in forum Queries
    Replies: 2
    Last Post: 02-17-2011, 08:11 AM
  2. Replies: 1
    Last Post: 02-16-2011, 09:08 AM
  3. Query showing unexpected results
    By johnmerlino in forum Queries
    Replies: 30
    Last Post: 10-25-2010, 07:08 AM
  4. Replies: 0
    Last Post: 02-24-2010, 12:56 AM
  5. Replies: 7
    Last Post: 12-07-2009, 07:27 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
  •  
Tech Forums: Microsoft Office Forums