combo box based on current record

[snewman]

I am making a form for customer company information. I want to be able to put the contact as a combo box with a separate contact form to show all contacts for a particular company. The each time we add an entry for this company we can select a contact for that particular job. But my combo box shows all contacts, not just contacts I have linked to that company. I have seen post for selecting the content of the combo based on another combo on the form, but I am trying to base it on the primary key of the current record. Does anyone have any ideas?

[June7]

You can use any criteria you want. If the primary key is saved as foreign key in the contacts table, then yes, use it as criteria.

If you navigate the form between companies, will need code that requeries the combobox. The real trick is figuring out what event to use. In this case, possibly the form OnCurrent event.

[orange]

Do you have a data model for your database that supports your business rules?
My idea is to have a data model, test data scenarios, and to make sure the model supports the scenarios before getting too deeply involved in Access specifics.

Good luck with your project and welcome to the forum.