Results 1 to 2 of 2

Thread: Look Up Tables

  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unhappy Unanswered: Look Up Tables

    Help Needed Please!

    I am a real novice so please have pity! I have created an Access really basic database and have used look up tables. Mostly this has worked well. However for 1 particular section of my form particularly I want my look up table to automatically display 3 fields and not just one

    At the moment I have 3 form entires from 3 different fileds all based on look up tables lists
    Name Address DOB
    I have worked so it displays all these 3 but and then just the Name is entered. So if I want the Address & DOB to appear I need to fill in another 2 entries.

    Is there any way that all 3 - Name Address DOB can be added once so that once I find the right name from the look up list the Address & DOB automatically are put in.

    Am I making any sense (confusing myself here!) and please can anyone help me

    Many thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Cleveland USA
    Posts
    184
    I've done something similar with subforms. On the main form, I have a combo box that lists the names. The subform shows all the employee details (DOB and Address in your case). Make sure you set your master and child fields, which will happen automatically if you have your relationships set up.

    For the combo box's AfterUpdate event (which means it activates when the name choice changes), I have this code. You can also create a macro that Requeries.

    Private Sub cmbEmployee_AfterUpdate()

    'After the user selects an employee name, requery
    'so the subform will have the most current info
    Me.Requery

    End Sub

Posting Permissions

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