Batch instead of individual items

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

  1. joeserrone

    joeserrone New Member

    Nov 14, 2008
    Likes Received:
    Trophy Points:
    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

    Jul 12, 2004
    Likes Received:
    Trophy Points:
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice