Setting up a Query for feeding combo boxes in multiple forms

[TheChrisLV]

I have the need for several forms in my database to use combo boxes that "feeds" another combo box on the same form. The most commonly used instance is using CompanyName_Combo Box as the criteria for the query Company_People that is used to feed the Employee_Name Combo Box. I use the following in the criteria of the query [Forms]![CompanyF]![C_InteractionF].[form]![CompanyID] and I enter in the correct Requery commands in the event codes to update the combo box. Everything works as intended but there are some issues I keep encountering.

1) In the set up above the form [C_InteractionF] that contains the combo boxes is a subform of the form [CompanyF]. Whenever I open [C_InteractionF] by its self or try to use it as a sub form in another form I am prompted for the parameter value. How can I avoid this.



2) Since I use this combo box method many times throughout my database I don't want to have to recreate the supporting query and change the criteria each time for the specific form I am creating I am looking for a way to define a parameter that I can assign values to in event codes that get passed to the query whenever I requery a combo box.

[June7]

Don't use parameterized query as combobox RowSource. Use SQL statement in the RowSource.

SELECT Employee_Name FROM Employees WHERE CompanyID = [cboCompanyID];

[TheChrisLV]

THANK YOU SO MUCH....I created a test form and that is exactly what I needed it to do As a quick follow up, what is a good resource for learning SQL

[June7]

Start with http://www.w3schools.com/sql/default.asp