Forms, Sub forms I don't really know what I want

[LeeG]

Hello, What I need is some information? I have created a table for deliveries, this is linked to another table that holds the names of the suppliers, I have created a form for this information but what I want it to do (if possible) is that when I select a certain supplier I get another form or boxes on the origional form that lets u select what quantity or service that supplier provides.
I.E. When I select supplier A from the look up box I get a second form/box that says Emptied waste bins or any other service they provide. Or when I select supplier B again a seperate form/box pops up allowing me to enter (for e.g.) 60 pallets paper delivered?

Is this possible or am I asking too much from Access???

Cheers.

 

[Shadez]

they easiest way to do this is with a sub form.

 

[OneRandomStone]

Forms - SubForms

Are you wanting to develop this program to handle purchase orders as well? Because getting the foundations sorted out at this stage will make it alot easier for developments in the future...

I take it that the deliveries table is some form of goods' receiving from an order table?

You can have a combobox to search for your suppliers, then place the supplierid field somewhere on the mainform (.visible = false) this can be used as the masterlink for any subforms you create to display all the suppliers services and or current orders awaiting delivery.

Hope this helps.