Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Iowa
    Posts
    13

    Exclamation Unanswered: Linking boxes in form problems???

    ok, im super frustrated...

    i have a table with an agency name, its address, and its phone number...all in different columns.

    i need to know how to select the agency in a combo box on a form, and then make the form automatically fill in an address and phone text box on that same form!

    ive tryed everything, please help...thank you so much

    BEN

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Don't get to frustrated...

    I'm assuming you already have all the agency names listed in your ComboBox. Try this method in the On Click event code window for your ComboBox:


    Code:
    Me.Filter = "[AgencyFieldNameInTable] = '" & Me.myFormComboBoxName & "'"
    Me.FilterOn = True
    Me.Requery
    Before you use this, make sure your ComboBox is putting out the expected string data when the the agency is selected. For example, do something like:

    MsgBox Me.myFormComboBoxName: Stop

    Place the MsgBox function line above as the first line in the On Click event. You can remove it later.

    Are you getting the agency name?....Great...Delete the MSgBox function and your in action.


Posting Permissions

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