Send value from control to query to populate cbo

[Zydeceltico]

Hi All!

On a single form I have cboJob that the user makes a selection from.

When a selection is made txtFinalProduct_FK is auto-populated with a numeric ID.

I have a second cbo that is based on a query that should take the numeric ID from txtFinalProduct as criteria.

How do I do that?

I'm guessing something happens with the After Update event of txtFinalProduct but I am struggling trying to figure out how to pass the value to the query underlying the second cbo (cboComponents).

Is this an instance of using VBA to run SQL on the After Update of txtFinalProduct?

Guidance is appreciated.

Thanks,

Tim

 

[theDBguy]

Hi Tim. You're on the right track. Do a search on "cascading combobox" because that's basically what you're trying to do.

 

[Zydeceltico]

I figured it out mostly.

Used the Builder to get the correct reference in the Criteria field.

I forgot I could right click in the criteria field and get there.

 

[theDBguy]

Glad to hear you got it sorted out. Good luck with your project.