Solved

Trying to replicate the Excel Indirect comand in Access

Posted on 2013-07-01
4
74 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
4 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

772 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