Drop down lists

[ptrifile]

I have a table that lists manufacturers and products. I would like to have a form with a drop down box and when a certain manufacturer is chosen in one drop down another drop down will only have those products that are associated with that chosen manufacturer. Can someone help me achieve this?

Thank you in acdvance!
Paul

 

[Remou]

Have a look here: faq702-4289.

 

[ptrifile]

Remou, thank you very much! That worked perfectly. This brings me to another question. If I want to have a separate text box on that form that will show a price for the model chosen would you know how to accomplish this?

Thanks again!

Paul

 

[ptrifile]

Remou, thanks again for the link. I figured out how to accomplish this.