Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250

    Unanswered: Gotta be an easier way to lookup info

    I have a secondary table linked by UserID. How do I easily display the info in the secondary User table (UserName, phone, etc.) on a form which uses the primary table as the record source in Access 2003?

    Using DLookup seems a bit tedious. Please, any suggestions?

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    .Recordsource = "SELECT tb.columnA, .. FROM tableB tb WHERE tb.ID = " & param
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    You can use a sub-form or query both tables and base the form off that query.
    Last edited by Darasen; 02-28-05 at 10:59. Reason: Must learn to type.
    Darasen

Posting Permissions

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