Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Macro for lookup list (Access 2003)

    I am very weak with conditional macros and wonder if someone would help me on this...

    I have a field for Director in the frmStudentRegistration, that when I choose a Director from the combo list I have made for that field, I would like ONLY the list of classes that this chosen instructor teaches to show in the next field that is a combo box as well called "Class Name". I am figuring this information will be pulled from the tblClassesByDirector, but am not sure how...

    Thanks for taking a look...am going to attach the db for you to look at.
    Attached Files Attached Files
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Macro for lookup list (Access 2003)

    See attached version. I added an AutoNumber field to the Directors table and used that to link to the other tables - much more efficient than a text field.
    I changed the Row Source of the ClassName combo box to select only classes that are taught by the selected director, and added code to the On Current event of the form and to the After Update event of the DirectorID combo box to requery the ClassName combo box.
    Attached Files Attached Files

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Macro for lookup list (Access 2003)

    Hans,

    You saved me again. This works beautifully, and is just what I was looking for. Thank you for the lesson here. I will use it a great deal in the future.

    Always so very grateful for all you do!
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •