form based on query

  • Thread starter Thread starter Meg
  • Start date Start date
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
 
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
 
Back
Top