Solved

Trying to replicate the Excel Indirect comand in Access

Posted on 2013-07-01
4
39 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
Comment Utility
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…

728 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now