How do I obtain an existing value and pass it to a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a database in Access 2000 that lists clients (Companies) and
learners for those clients. The Clients and learner data are in separate
tables. The common link is the Company name. I would like to include a button
on the Clients form whereby when pressed, the current company name is
obtained and a query is run on the learner table to extract all learners sent
by that company. This information will then be viewed in either a report or a
form.

How do I obtain the company value currently displayed on the client form and
pass it to the query?
 
In query design view you could put criteria for the company field like
=Forms!NameOfClientsForm!NameOfTheCompanyControl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto-populate field based on info entered into other field 0
Mail Merge and Print Query 1
Function needed to search and pull data from 1 table to another 4
Access Determine what query to run based on a checkbox 0
appending a Learner and Aims set of records to a txt file 4
using sub forms 8
Lookup and Replace value in multiple tables 2
update many fields in a form from existing info. 2

Back
Top