Embedding Queries ???

[spudmizer]

Ok Here is what I am aiming for

User click the text "Create Order" on the MAIN form
I am want it to open two "subforms" on the screen one
above the other like this
_____________________________________________
|Creat Order Subform 1
| ---------
| Subform 2
|
|---------------------------------------------|
In subform 1 is the query part.
The user type in a Item Number, then it pulls the rest of the information for an already created "Item Information Table" about that item, if the items not found it allows the user to fill in the rest of the fields manually and add it too the database
( sorry off subject, abit ) with a qty to order field. ANYWAYS there is a button that says "ADD ITEM" which post the item to subform two, subform two, when the order is complete, will then be queried to a report, using the "Order Complete" button.

So what I am needing help on is
1) Verify that "Subforms is the thing to use"
2) How to post the item from subform 1 into Subform 2
3) Query Subform 2 into a printable report !!!
4) How do I make the Subforms appear, then dissapear
when another button is clicked OUTSIDE the two
subforms !!

Need more info PLEASE just ask !!!