I am trying to pull up only the PO numbers and Part numbers for only one Vender.

[jgb]

I am trying to pull up only the PO numbers and Part numbers for only one Vender.

I would like to select a Vender (Combobox1) then I need only the PO numbers (Combobox3) and Part numbers (Combobox5) for that Vender only to come up.

I can pull up all the Vender names in Combobox1, all the PO numbers in Combobox3 and all the Part numbers Combobox5. I did this for each combobox in Properties > Data > Row Source

Then I have a Command Button made to run a Vender report.

Thank for any help to a beginner.
Jack.


From a Form1
Combobox1 – has Vender names from Collum1 of Table1.
Combobox3 - has PO numbers from Collum2 of Table1.
Combobox5 - has Part numbers from Collum3 of Table1.

 

[pbaldy]

See if this helps:

http://www.baldyweb.com/CascadingCombo.htm

 

[jgb]

Thank Paul. I'll try it latter tonight.