Results 1 to 3 of 3
  1. #1
    Willtc is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2010

    List Boxes.

    Hi all.

    I am currently mid way through creating a program for my A level Computing exam coursework. I am using Access to create a program to grade students in a year group. I am using list boxes to filter out which students do which classes and then allowing the user to select a grade and comment for the specified student.

    What I wanted to ask you guys, is how I can make it so that once the user clicks on the next student in the list box to add data to, if there is already data saved to that student (a comment and grade) in the table linked to the form, it is displayed in the comment box and the grade to the right.

    Thanks in advance,


    P.S. I have attatched a copy of the code from the form + a screenshot of the form itself.

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Let me get this straight. you want that grade and comment if already added for a particular Child for a particular student that the user should get a prompt that data is already being entered and then the user will get an option either to abort or to modify the exsiting data. Now you have to tell me whether I am right if I am on the right track please send me your table structure so that I may be able to suggest a solution.


    please send it on for speedy response.

  3. #3
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009

    List Box

    Hi will I hope you wil excuse me for the scrapy work. I just designed something for you. I am attaching a database.

    Go to Forms:

    You will find two list Boxes Classes and Students. Once you select a subject the students taking that following subject will appear in the student list box.

    Now try entering comments:

    Select a subject then a student name on the respective list boxes. Selectan option on the option group and then type a comment on the text box (Text 33). Click on the save button. The comment is saved. Try re-entering the same comment by clicking the save button msgbox prompts that comment is already entered.

    Now change the comment and press the save button again the msgbox prompts that comment is already entered and presents you with two options Yes and No. No aborts keeping your original comment intact and if you click yes your comment is updated.

    I designed this in 30 min during my lunch break in my office. I have used office 2000 and thus you might have to convert the database. In our office we use ubuntu open source only I have a lap with microsoft office 2000.

    please let me know if your problem is solved if it does please to post the VBA codes on the forum and mark the thread solved.

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

Similar Threads

  1. 2 multi select list boxes on one search form
    By woodey2002 in forum Forms
    Replies: 2
    Last Post: 11-05-2010, 12:44 PM
  2. Replies: 1
    Last Post: 07-30-2009, 12:54 PM
  3. List box to populate other list boxes
    By Nathan in forum Forms
    Replies: 0
    Last Post: 03-03-2009, 07:22 PM
  4. Replies: 1
    Last Post: 03-01-2009, 09:53 AM
  5. Replies: 0
    Last Post: 02-26-2009, 03:34 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 - Senior Forums