Populating Table with Form

[bossmack916]

I have a list of Vendors who each have their own set of products and pricing. I am trying to create an order form that will allow the user to select a product by Vendor and have the details of that product displayed so that the user can select the quantity and discount of the price. Once the total is calculated, I want to be able to add this order to an Orders table.

I am having a difficult time creating this being that I have about 20 diff vendors with their own product set and dont know how to create a single form to do this without creating queries and a different order form for each vendor. Please assist!!

 

[JHB]

Use a form and with a sub-form linked together.
Or a form with a Combo-boks, then you use filter.

And use a button, to add the order to the Orders table.

 

[bossmack916]

Yes but how do you add it to the Orders table? What is the vbcode? SQL?

 

[JHB]

Microsoft Dev Center provides a good example
http://msdn.microsoft.com/en-us/library/office/bb208861(v=office.12).aspx

 

[Pat Hartman]

You don't need any code to do this. If you didn't install the Northwind database when you installed Access, download it now (or install it from your installation CD). Northwind should give you some idea how forms work.