lookup question

Discussion in 'Access Forms Coding' started by Mike106, Dec 31, 2012.

  1. Mike106

    Mike106 Guest

    I have a form with fields bound to table1. Field1 is a combo list that is populated by values from field1 in table2. Tsble2 has other fields that correspond to fields in table1. When I am adding a new record in talbe1 and select a choice in the field1 combo list that would have the same value in field1 in table2, I would like to have the corresponding values from the corresponding table2 fields to appear in the form but not necessarily accepting the values before I commit the record to the table. How do I accomplishthis? I am new to VBA.
     
    Mike106, Dec 31, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. JB_96RS

    Lookup question

    JB_96RS, Jan 13, 2004, in forum: Access Forms Coding
    Replies:
    1
    Views:
    84
    Howhiareu
    Jan 13, 2004
  2. Stacey

    Lookup question

    Stacey, Nov 5, 2004, in forum: Access Forms Coding
    Replies:
    2
    Views:
    93
    Stacey
    Nov 8, 2004
  3. Strodiggity

    Lookup newbie question

    Strodiggity, Sep 8, 2005, in forum: Access Forms Coding
    Replies:
    1
    Views:
    87
    Larry Linson
    Sep 10, 2005
  4. siggy

    d-lookup question

    siggy, Aug 3, 2006, in forum: Access Forms Coding
    Replies:
    4
    Views:
    119
    Allen Browne
    Aug 4, 2006
  5. FilemakerPro_Developer

    click event question and pass a filter question

    FilemakerPro_Developer, Jan 30, 2007, in forum: Access Forms Coding
    Replies:
    2
    Views:
    144
    FilemakerPro_Developer
    Jan 30, 2007
  6. YuXuan-ji

    further question on adding values to lookup tables

    YuXuan-ji, Jun 22, 2007, in forum: Access Forms Coding
    Replies:
    1
    Views:
    101
    Dale Fye
    Jun 22, 2007
  7. ielmrani via AccessMonster.com

    Lookup table question

    ielmrani via AccessMonster.com, Apr 22, 2008, in forum: Access Forms Coding
    Replies:
    3
    Views:
    80
    ielmrani via AccessMonster.com
    Apr 22, 2008
  8. aw
    Replies:
    1
    Views:
    123
    Amy E. Baggott
    May 14, 2010
Loading...