Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2009
    Posts
    3

    Question Unanswered: Populate field in table based on another field selection

    I am creating a table that has minimal fields, which I will then use to create a form for the user. Essentially what I would like it to do is for the user to select a memo number from a drop down menu and based on the number they select the memo title field will auto populate. I have the memo number field set to combo box with the data being pulled from another table, however how do I get the title to auto populate.

    Any help is greatly appreciated

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Are you trying to do this in tables? If so, DON'T.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Sep 2009
    Posts
    3
    No, I have created a form based on the information in my table. I would like the form to look up a field based on a selection in the preceeding field and in turn update the table that its linked to.

  4. #4
    Join Date
    Sep 2009
    Location
    Longview, Wa.
    Posts
    3

    Possible Fix

    Do you know VBA? If so you could write something like this in your combo box's On Change event procedure.

    Select Case MyComboBox.Text
    Case "VariableA"
    Me.MyTextBox.Text = "MyValueA"
    Case "VariableB"
    Me.MyTextBox.Text = "MyValueB"
    Case "VariableC"
    Me.MyTextBox.Text = "MyValueC"
    End Select

    Let me know if this helps.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    If the table you are using for your combo box list (tblMemo maybe) is included in the forms underlying query and there is a relationship between the table you're entering data for and the tblMemo, then the field will "autopopulate" when a memo is selected... without code.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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