Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Batch instead of individual items (http://www.go4expert.com/forums/batch-instead-individual-items-t15140/)

joeserrone 15Nov2008 00:12

Batch instead of individual items
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!

shabbir 15Nov2008 10:22

Re: Batch instead of individual items
Please try to post in the post itself rather than an attachment for your query. I have removed the attachment as of now.

All times are GMT +5.5. The time now is 16:00.