3RD Tier Combo Box

[Jademonkey2k]

Heya guys,



I was wandering if anyone could help me, im tearing my hear out at a problem with combox boxes based on selections of another combo box.

I can get the 2nd Combo box to display corectly based on the selection of the first. But getting the 3rd to display corectly based on the second is driving me insaine lol


What i have is a database that has a some tables (Suppliers, Materials, Contracts)

What i am trying to do is to add a subform in contracts to keep a record of what materials have been used with what contracts. Im not really having an issue with this, however entering the material data in the subform on the contracts form is whats causing the problems.

The user has a set of options to add a new material to a contract, The supplier, the material itself and the unit price. I can get it to display the Suppliers, and what materials they supply based on relating combo boxes, hower when i try to get it to display the unit price based on the material selection it simply doesnt wanna know.

Iv gone through the SQL code over and over again and i really cant see a reason for it, any help would be appreciated

Iv uploaded a sample of what im trying to accomplish below, just open the contracts form to see the problem

Linky -
http://www.quickfiles.net/535395 (Download Link)

[RuralGuy]

Let me start you off here: http://www.mvps.org/access/lookupfields.htm

[Jademonkey2k]

Thanks for the link man, had a lookie thorugh it but i dont think it relates to the problem im having. When opening the contracts form its not throwing an error at me. Its getting the information i require for the 1st and 2nd combo box with no problem. The issue is that its simply not getting the data for the 3rd box based on the selection of the 2nd box.

Im using the same SQL methord to get the data for the 3rd box, it worked on the second but not the 3rd. I must be blind cause i cant see any reason for it lol

[Jademonkey2k]

My appologies RualGuy, i re-read the link you posted and indeed it resolved the issue. When i made the selection from the first combo box, it actuly returns the ID of material in question for the 2nd combo box and not the name. While the name is displayed in the combo box its actuly the ID its referncing.

On the 3rd combo box, all i had to do was make the SQL statement refer to the MaterialID in the Materials table from the MaterialName in the subform [Material Name in subform is actuly masked at the MaterialID].

Cant belive i didnt see that before, but thank you for the help, hope this post helps anyone else with the same issue

[RuralGuy]

All LookUp Fields do is help confuse the programmer. Everything they do can be done with a ComboBox on a form. Glad to hear it pointed you in the right direction. Are you ready to follow the link in my sig in post #2 and mark this thread as Solved?