?
Solved

Trying to replicate the Excel Indirect comand in Access

Posted on 2013-07-01
4
Medium Priority
?
126 Views
Last Modified: 2016-04-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.
0
Comment
Question by:Aljobu
1 Comment
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 39294246
I would implement this using a "parent" form for Trades, and a subform for Specialties.  When you do it this way, Access will ask you which fields to use to join the two together.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question