Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ComboBox DLookup (2002)

    I have a combo box on a Sales Invoice form: cboShipTo.
    cboShipTo is populated with Vendor Names from tblVendors.
    I made a query that concantenates: address, city, state and zip. AddressCalcLookup.
    The Query has tblVendors as it's table.
    I want to have when cboShipTo is selected put the matching Vendor Name's address in ShipToAddressField on the invoice form .
    Frank Hoeffer

  2. #2
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ComboBox DLookup (2002)

    make your combo box have 2 columns. One the vendor name the other the concantenated address. The second column does not even have to show. Set the afterUpdate event to put the second column of the combo box in the appropriate field. i.e. me.cboShipTo.Column(1)

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    San Francisco, CA, USA
    Posts
    184
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ComboBox DLookup (2002)

    Brillant! <img src=/S/bouncenburn.gif border=0 alt=bouncenburn width=31 height=31>
    Thanks Frank

Posting Permissions

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