2 combo boxes based on each other

[vid]

Hi!

Basically I'm creating a database in which i have 2 fields called "Product Code" and "Product Name" respectively in one table each with a number of entries.

What i require is that in the form if someone choses a particular Product Name the corresponding Poduct Code should appear on its own and if someone choses a particular Product Code its corresponding Product Name should appear on its own. I'm able to create a one way relationship but I have no idea how to create a 2 way. basically if any one of them is selected the corresponding value of the other one from the Products table should appear on its own. I hope you understand my problem!

Please help.. No idea what to do!!!!

thanks

 

[Rich]

Search here for Cascading combo boxes, there have been many posts on the subject

 

[georgedwilkinson]

I don't know what the word "appear" means. My assumption is that you are using a bound form (I hope).

I believe what you are trying to do is to filter your bound form (I hope). Start with Access' built in filtering. Right click on the field you want to filter on, and type in your filter criteria in the supplied spot. If that works for you and you still want to filter based on one or more combo-boxes, read this (http://www.allenbrowne.com/ser-03.html) first and follow up here with any additional specific questions you may have.