Results 1 to 12 of 12
  1. #1
    Join Date
    Aug 2003
    Posts
    160

    Unanswered: Listbox records selection

    Hi! I have a list box on a Subform whose source is from a table. This subform is linked to main form.

    I want to select multiple items from the list box and when I move to next record those selected records must be saved and when I get back to the same record it must show the same selected records.

    Any Help

    Thanks

    Vad
    Vad

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Is not easy.....thing that you need a temporal table, when you select a record in the main form add the relation item to the temporal table with a field that link to the record in the main form.
    The list box have the record source from the temporal table, the query for the list box must have a criteria with the record select in the main form.
    When you close the main form remove all the records of the temporal table.
    Saludos
    Norberto

  3. #3
    Join Date
    Aug 2003
    Posts
    160
    I am an access baby, could u give me samole code of that.

    Could you explain me more clearly.

    Thanks
    Vad

    Originally posted by Norberto
    Is not easy.....thing that you need a temporal table, when you select a record in the main form add the relation item to the temporal table with a field that link to the record in the main form.
    The list box have the record source from the temporal table, the query for the list box must have a criteria with the record select in the main form.
    When you close the main form remove all the records of the temporal table.
    Vad

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Tell me point by point what you do not understand.
    Saludos
    Norberto

  5. #5
    Join Date
    Aug 2003
    Posts
    160
    Actually What I have was:

    ClientsTable: I created a main form using this table
    ClientID(PK)
    Lastname
    FirstName

    Titles Table:
    TitleID(PK)
    ClientID(FK)
    Titledescription

    Subform Using Titles Table with fields TitleID and ClientID and a listbox whose rowsource is Titlestable, bound to TitleDescription

    For each record in main form I want to select several titles in subform.

    Now Based on this could u explain me the steps how to create a intermediate table and rest of the thing. I don,t know VBA coding. Could u helpme out of this.

    Thank U very Much

    Vad





    Originally posted by Norberto
    Tell me point by point what you do not understand.
    Vad

  6. #6
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Vad:
    Like you see i don't speak good english, and you don't know VBA coding them both make create a monster. Is more easy that you send to me a sample base in Access 97 i see what i can do and send to you with the update. And then you study how i do it.
    ok
    Saludos
    Norberto

  7. #7
    Join Date
    Aug 2003
    Posts
    160
    Norberto:

    Here I am sending the sample database.If u need some more explanation please ask me.

    Vad


    Originally posted by Norberto
    Vad:
    Like you see i don't speak good english, and you don't know VBA coding them both make create a monster. Is more easy that you send to me a sample base in Access 97 i see what i can do and send to you with the update. And then you study how i do it.
    ok
    Attached Files Attached Files
    Vad

  8. #8
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Vad :
    I can read your file, is not in format data base Access 97.....zip.
    Try again.
    Saludos
    Norberto

  9. #9
    Join Date
    Aug 2003
    Posts
    160
    Here I am sendong the Access 97 format.



    Originally posted by Norberto
    Vad :
    I can read your file, is not in format data base Access 97.....zip.
    Try again.
    Attached Files Attached Files
    Vad

  10. #10
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Vad:
    With the item selects ( a few ) for a client what do you do...?
    Saludos
    Norberto

  11. #11
    Join Date
    Aug 2003
    Posts
    160
    The Titles to the Clients must be unique. If I search for a client all the Titles assigned to him must showup.

    Thank U


    UOTE]Originally posted by Norberto
    Vad:
    With the item selects ( a few ) for a client what do you do...?
    [/QUOTE]
    Vad

  12. #12
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    465
    Originally posted by vad
    The Titles to the Clients must be unique. If I search for a client all the Titles assigned to him must showup.

    Thank U


    UOTE]Originally posted by Norberto
    Vad:
    With the item selects ( a few ) for a client what do you do...?
    [/QUOTE]

    I send to your base with the update.
    I make a new form call "Client/Titles" this form have:
    1) A combox where the users select the client.
    2) Two List Box: The first list box tell what Titles have assign the Client
    select in point 1) the second List box tell for the item select in the first
    list box, other clients with that item.
    Attached Files Attached Files
    Saludos
    Norberto

Posting Permissions

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