Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    Unanswered: Textbox returning value based on object

    What I'm trying to do is make a textbox return the "classdescription" from a table where I use a combo box to select it. I managed to get the information to display for last name but it was only because the linked table had the field I need.
    I have attached a picture of what I'm trying to do
    Attached Thumbnails Attached Thumbnails return driver input.png  

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    You can assign the RowSource property of the combo to a query that associates both table (using an INNER JOIN). You can retrieve the value of a specific column from a combo using the following syntax:
    MyTextBox.Value = MyCombo.Column(n)
    With n being the index of the column (0 for the first [leftmost] column, 1 for the second... etc.). You can hide the columns you do not want to see by properly setting the ColumnWidths property of the combo.
    Have a nice day!

Tags for this Thread

Posting Permissions

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