Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    14

    Unanswered: seperating 2 items from a lookup to create running total in query

    I have a field called Extras in an order form - I have used a lookupwizard with two columns to store the data - for example - Item, Cost fields- teddy, 3.34;balloon,4.50. When I create a query to work out invoice - I want to be able to seperate them and display them or as many that have been selected. I have tried using Expression Builder but no joy - using Access 2010 - thanks in advance

  2. #2
    Join Date
    Apr 2004
    Location
    Kingsland, Georgia
    Posts
    231
    I'm not sure what a lookupwizard is - i'm thinking along the lines of a listbox? If you're needing a routine to display all of those, you could approach it like this:
    Code:
    Dim varItem as Variant
    
    For Each varItem In lstWhatever.ItemsSelected
       'Do something here with lstWhtever.Column(0) and lstWhtever.Column(1)
    Next

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
  •