?
Solved

Trying to replicate the Excel Indirect comand in Access

Posted on 2013-07-01
4
Medium Priority
?
114 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

800 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