Combo to List to List then select

[monkeyshack]

Hello,
Thank you everyone for helping me along this far.. but now I am stuck and need some help.

What I have a database that helps match companies to projects. In one part of the db we enter company data and trades and on the other side we enter project data and bid items.

What needs to happen next [where I am stuck] is match the potential companies with the projects via bid items.

I am trying to use a combo box that lists the projects, when you select the project I want it to list the bid items, then I want to be able to then click on each bid item where it will list the companies that do that trade/bid item. After that I want to be able to use a checkbox to add those companies to the bid contact listing...

Match based on bid item and district.

Please let me know if you need me to clarify. I will post the relationships. I imagine that when you click on the check-box to add them it dumps the data to the tblBidContact.

I can get the combo to list the bid items in a subform.. I think I'd rather have it in a listbox... but cant figure that out or I cant figure out how I should approach this whole part.

Thanks for your help.

 

[Jakboi]

Hello,
Thank you everyone for helping me along this far.. but now I am stuck and need some help.

Im rather new so my experience wouldnt really help you...but this is your first post unless you just copied and pasted this from other forums...ah ha.

Well your welcome!

 

[monkeyshack]

No, I have been trolling around for a few weeks reading and searching that’s what the gratitude is for.

 

[monkeyshack]

ok I have figured out the combo to list. How do I now get the list to update a subform. ie on click then display what matches...

 

[rborob]

can you not set the row source of the list box to contain criteria selected from the combo box? i.e. " WHERE someID = Me.cboCombo.column(0)"

 

[rborob]

Ok say your combo box has a list of the projects, on the after update set a text box (hidden of course) to the ID for that project.

After update:
Me.txtbox = Me.combo.column(0)

Then you have your row source for the "bid items" list box. Use the ID in the text box as criteria (e.g. WHERE ProjectID = Me.txtbox ) and have it requeried every time the combo box is updated. This way you will always have the relevant Bid items in the list box. You can then do the same for the second list box.