form based on query

M

Meg

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
 
M

MacDermott

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
 
Top