1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Batch instead of individual items

Discussion in 'MS Access' started by joeserrone, Nov 14, 2008.

  1. joeserrone

    joeserrone New Member

    Joined:
    Nov 14, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Hello Everyone,
    I have a problem I'm trying to resolve and wanted your opinion on this. I currently have a form that displays a list of items from a table. I then use the code in the form button to assign the items highlighted to a specific person from a drop down box. The problem I'm having is that many items can be part of a batch called Advice, instead of highlighting every item in the batch I would like to basically have only the advice numbers showing in the batch and when I run my assign code basically assign all the items in that advice to the person selected from the drop down box.
    So for example if Advice# 123456 has 5 items, instead of highlighting all 5 items and assigning them to bob I want to simply highlight the 1 advice 123456 and all 5 items will be assigned to Bob.
    I changed my query in the form to show me only the advices by Group but naturally when I try to assign them using the code below it simply doesn't work.

    Attached is the sample database I came up with so far. Any ideas how I might be able to overcome this?

    Thanks as always for all you help!
     
    Last edited by a moderator: Nov 15, 2008
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    Please try to post in the post itself rather than an attachment for your query. I have removed the attachment as of now.
     

Share This Page