Report from query

[M0E-lnx]

I'm working on a database similar to a sales databse (except this is for buying stuff).
There are transactions, and each transaction has a lot of items in it. Think of this as an invoice... You have one invoice, and several line items in each invoice.

I've designed a query that groups can group all the items for an order number(say 10) and list them correctly.

But the problem here is that in order for this to work, the query needs to know which order I'm looking for ... so for now, have this in one of the query criteria boxes (the orderNo field)

=["Enter order number"]

so it prompts for the order number and then displays the results.

What I need is a way to bypass that prompt and just tell it via a button... "I need to see what's on order # 10"

Anyone ever done something like this?

 

[pbaldy]

I assume you mean you're running the report from a form that's displaying the desired record, in which case I'd use this technique:

http://www.baldyweb.com/wherecondition.htm

 

[M0E-lnx]

Thanks... That helped.