Link One Combobox to Another Combobox

[Allienne]

Hello!

I have a form with a combo box. Inside that form I have a subform with another combo box. In ComboBox1 there is a Job #. In ComboBox2 I want the proposal Number that connects to that Job # so I can populate data using that. I would also like ComboBox2 to default to the top item which should be the specific proposal number.



If I can't link the ComboBox1 to ComboBox2, is there a way to link ComboBox1 to a TextBox in that subform instead?



Thank you!

[June7]

You select JobNo and want combo2 to be limited to proposals associated with that job number? The main and subform are linked by JobNo (Master/Child Links)?

What you want is called cascading comboboxes, a common topic.

Advise not using space nor punctuation/special characters (underscore only exception) in naming convention.

[apr pillai]

1. Create a SELECT Query, with the Main Form ComboBox Source Data, use the JOB# combobox current contents as criteria to filter the data as Source for the second ComboBox on the Sub-Form.
2. On the Main Form Combobox Click_Event you must add me.comboxname.Refresh in the Form module, to update the underlying query, based on the change of JOB# in the Combobox.
3. Use the new Query Recordset as Source for the second Combobox.

When you Click on the JOB# Combobox to select an item from the list, it's corresponding Proposal Number list will appear in the Sub-Form Combobox.

[June7]

Review https://www.accessforums.net/showthread.php?t=74891

Yes subform combobox can reference textbox in subform, such as the textbox holding the JobNo foreign key. What data is entered into the subform?