Query about a Query

[edawson]

G'day everyone,

I have designed a query, using wizard, which asks what drawings you want to view from a particular drawer in my drawing system (all the drawings, 1191, are in a Table).
I have also designed a form containing a command box saying "Find drawing using Drawer Number" and I would like the above query to appear when you click this command box - then the chosen report should appear on screen.

If anyone has any ideas please help me out.

Cheers - Elliot

 

[FoFa]

You should not need all that to find a drawer for a drawing number, assuming it is unique (a drawing number is unique and can only be in one drawer). You should be able to use a DLOOKUP and put the return value in a text box on the form. If however you can have multiple returns (say due to revision numbers as an example) than you could use a list box so they could select the proper one for what ever you require next.
But if you need to continue down the road you are on (and I understand correctly) you can design a query that reads a value from a form (parameter, drawing number in this case) and base a report off of that, then all you have to do is run the report from your button.