Trying to replicate the Excel Indirect comand in Access
Posted on 2013-07-01
I have two tables: Trades and Specialty, each Trade has multiple Specialties. How do I use you use the value of the Trade combobox in a form as criteria for the rowsource of the Specialty combobox?
The following expression in Row Source works for the Trade “General Construction”:
SELECT Specialty_tbl.specialty FROM Specialty_tbl WHERE (((Specialty_tbl.[trade])="general construction"));
How do I replace “General Construction” with a statement that will point it to the combo Box in the form where I selected the Trade?
I’m not very good with VBA so I’m doing this in the Form properties or the query properties window.