I'm drawing a blank on how to do this.
I have a table (orderdetail)with order numbers and detail
info.
I have a query (ordernumberquery) which has the order
numbers grouped so that I can use them in a combo box
without duplications.
I have a query (ordersummary) which totals various fields
in my order table by order.
I want a form with a combo box for ordernumberquery.
When the user picks the order they want to look at, it
gives totalorder from the ordersummary.
Any and all help is greatly appreciated!
Thanks,
Meg
MacDermott - 29 May 2004 02:49 GMT
Make a form based on your OrderNumberQuery (I find names easier to read with
a few capital letters scattered in.)
Put a combobox on it -
use the 3rd option on the combobox - go to a record based on your
choice.
The wizard should walk you through the rest.
HTH
- Turtle
> I'm drawing a blank on how to do this.
> I have a table (orderdetail)with order numbers and detail
[quoted text clipped - 11 lines]
> Thanks,
> Meg