Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2003
    Location
    Kansas City, Kansas, USA
    Posts
    76
    Thanks
    1
    Thanked 0 Times in 0 Posts

    ck box to update from a table (2003)

    Ok here is the deal, I have a pretty complicated form. It is baised off of the table that I have for clients. On the form is a tab control that has several different subforms. On the first tab it has the client info and two subforms. The first subform is for address (i have a seperate address table) and the second is for contacts. What I would like to somehow do is to have a combo box on the contact subform and have it show only the address options for that client. For example, Client #1 has three address, 1. main address, 2. billing address and 3. shipping address so, when I am entering in contacts, (often, the contact address is the same as the main address) i want to be able to pick from only one of the three address listed in the address table. Can you help??

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: ck box to update from a table (2003)

    You could create a query based on the addresses table that selects only the addresses for the current client on the main form. Say that the main form is named frmClients, and that the client is identified by a field/control ClientID. The criteria for the ClientID field in the addresses table would be

    [Forms]![frmClients]![ClientID]

    Set the Row Source property of the combo box on the subform to the name of the query. You must requery the combo box in the On Current event of the main form:

    Private Sub Form_Current()
    Me!SubFormName!ComboBoxName.Requery
    End Sub

    Substitute the appropriate names; you must use the name of the subform as a control on the main form - this is not necessarily the name of the subform in the database window.

  3. #3
    Star Lounger
    Join Date
    May 2003
    Location
    Kansas City, Kansas, USA
    Posts
    76
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: ck box to update from a table (2003)

    THANK YOU THANK YOU THANK YOU!!!!!

Posting Permissions

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