MS Access Form Link Combo Box
Posted on 2014-09-11
I have two combo boxes on a form. Combo1 and Combo2.
Combo1 has a SQL statement as it's rowsource and works as expected.
I would like for Combo2 to be populated based on the value selected from Combo1.
Which Combo1 event property should I use?
What should the Combo2 row source be?
?? Syntax ???
Combo2.RowSource = SELECT Column1, Column 2 FROM Table2 WHERE Table1.SelectedColumn = Combo2.Selectedvalue
I can do this in c# using ASP.NET. MS Access is somewhat different.
I have not used MS Access since Version 2.0
A few hints will do. I taught MS Access at a local community college 15 years ago.