Query Criteria Based on Item Selected???

[P.Malius]

Hello, my database is used for tracking inventory items, I have a form which uses a subform based on a query which totals up order quantities(when picking items they are group for the ease of the storeman however they are stored in the database by the location they are being delivered to). E.G. 2 pens have to go to location 'A' and 3 pens have to go to location 'B', all the store man will see is 5 pens and he needs to be able to tick off that the items have been gathered for delivery.

The subform is formatted as a datasheet. As it stands the subform is not updatable. Part of the datasheet is a yes/no box for if the items are issued, my thinking is if I can use a query to pull up the individual location items when the storeman clicks on 'issued' then I can use update queries to say the items have been gathered.

Long story short, I want to know if a query criteria can be based on a value in the form.

Any help will be much appreciated.

[pbaldy]

Sure, just put the full form reference in the criteria. In design view you can right click and select Build.

[P.Malius]

Sure, just put the full form reference in the criteria. In design view you can right click and select Build.

Hi, thanks for your answer.

I have tried this before but without success. When I try this method I get the message box to enter my query criteria. I presumed it was because I was using a datasheet as the subform so there was no direct link to the value I wanted. I want to use as least operator input as possible so if I can limit it to one click of a button that would be great.

[Parsonshere]

docmd.RunCommand acCmdSaveRecord If you can add that prior to trying to pull criteria, it may help. Are you running this from the Boolean checkbox event procedure? This is tricky, sometime I have to make it a two step process, it just don't seem to work inside one routine, so I wind up calling a second subroutine from the first. Seems like I always get it to work, but I never really understand what the real fix was, and sometimes my not working routine will work after I reboot. go figure. It only happens when I attempt to do what you are doing here though.

[pbaldy]

Was the form open when the query ran? It has to be.

[P.Malius]

Hi, An update, Firstly, of course my form was open as you said, it had to be . Furthermore my problem has been solved. To get around the issue, a text box was place onto the form I was using, this was then reference to the datasheet which pulled up the first item on the list the query was then build to use this text box as a criteria rather than trying to reference a point in the datasheet. Thanks for your replies guys, I appreciate the efforts .