Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    16

    Unanswered: Howto display lookup value in a text box?

    Hi,

    I'm trying the following:
    I have a Passenger table with names (PassengerID, First name, Last name, etc.)
    I have another table with Cars. (CarID, Licence plate, etc.)
    A third table, called Travels contains Car IDs and 4 Passenger IDs - Who travelled in which car (TravelID, Date, CarID, Pass1ID, Pass2ID, Pass3ID, Pass4ID)
    Passengers.PassengerID has one-to-many relationships with Travels.Pass1ID, Pass2ID, Pass3ID, Pass4ID, since one passenger can make several trips.

    I want to show display data on a form like this:
    Travel1 - Date, Car, Passenger1 full name, Passenger2 full name, etc.
    Travel2 - Date, Car, Passenger1 full name, Passenger2 full name, etc.
    etc.

    I can do it with combo boxes, but I don't want to have the little drop-down arrow on the right of the box. That's why I'm trying to use text boxes. Any hint how to implement this?
    Axel

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Can't you just use a dlookup?
    Me.Geek = True

  3. #3
    Join Date
    Feb 2007
    Posts
    16
    Hi,
    Thanks a lot, this is what I'm looking for.

    Axel

Posting Permissions

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