Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: Combobox and Autofill Question(s)

    Is it possible to have a combobox that pulls records or record information from another table and then finds a record on a different table? I know that sounds confusing so let me explain it with names.

    I have frmFitness that has an ID combobox. The values for the ID combobox are being pulled from a tblMain. The other fields in frmFitness are coming from tblFitness. The two tables are linked using their respective ID fields. tblMain will always have the information before tblFitness which is why frmFitness is pulling the ID from tblMain instead of having it be typed in a textbox. Does anyone know how I can autofill the rest of the frmFitness even though the ID combobox is pulling from a different table than the other fields? After that, does anyone know how to have it add a new record for the respective ID if there is no information on that record yet?

    Let me know if you need further clarification in order to answer the question, I know it sounds confusing.

  2. #2
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 10
    Yes as long as the data is link

    You can Give the width of the coloum 0 which Hide then

    in the Coloum width you mite have 0;2.50;0;0;0;0
    coloum count = 6 <= very important

    Then in the code you can get the data by
    bla = me.combobox.coloum(3)

    I find this faster than doing a Dlookup()
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

  3. #3
    Join Date
    May 2006
    but doesn't that only work when you are getting the values from the same table? The information that I need to fill in automatically is mainly all from a different table. Combobox pulls from tblMain and I need the other fields to autofill from tblFitness.

Posting Permissions

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