Stuck with Form Help Please!

[silentwolf]

Hi Guys,
I got stuck in developing my userform and would love to get help from you guys!
I have a link to the datatables I am currently working on.

Below the table structure I am currently working on
http://img31.imageshack.us/i/werkzeugv1.jpg/

below the form I created
http://img156.imageshack.us/i/frmmodel.jpg/

below the second part of the form
http://img703.imageshack.us/i/frmtools.jpg/


tblWerkzeugTyp = Tool Typ
tblWerkzeug = Tools
tblHerWerkzeug = ManufacturerTools
tblHersteller = Manufacturer
tblModel = Model
tblVPE = Packaging Units
tblLiefWerkzeug = SupplierTools

So when I select the tooltyp and tools then it shows me the relevant tools in the form.
When I select the Model then in Details it shows me the Model and in what packeging units that model can be bought.
But now I like in VPE what supplier sales that model to what price.

This I can not get I am afraid
Also I am not sure if I supose to have a query or not as I am not sure if all the info has been entered correctly and I like to be able to make adjustments when I need to.

I would hope if someone could help me please as it is a bit to complex for me and I am working on this for a long time without any luck

Many thanks
Albert