Forms and subforms

[mgstlucia]

Hi,

This is what I'm trying to do. I just want to know if it is possible before I spend days trying to firgure it out. You don't know to give me details, give point me in the right direction.

I'm creating a form (Order Form), where the customer info comes from a table named (Customers). I then what to create a subform using the (Products) table. I want to have the SKU# number be a Combobox and autofill the rest of the fields except Quantity and Total Price. I already figured out how to do this in a form and I am assuming it is the same in a subform.

When the order is complete, I then want it to update an Orders table to track who is ordering what and the total amount.

The Customer and Products table are linked.

What links do I need to create?
Anything I should know about putting the subform into the Main Form

Thanks

[lee123]

so your saying that when you click on the combo box and choose the item(s)
it will fill the subform? if so then what i would do is this:

fieldname = comboboxname.cloumn(0)
fieldname = comboboxname.column(1)

lee123

[lee123]

oh yea if you want it to go to a new line put this before the code

DoCmd.GoToRecord , , acNewRec

lee123

[mgstlucia]

What I am saying is will I be able to put a subform into a main form which has the capablable of using a combobox. When the entire form is filled out, I what to update an ORDERS table with all the info on the form. I'm not sure what code to use for that and where to put it.

Thanks for the next line command. I will need that soon.