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

[Alastair]

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?

 

[Svetlana]

In query design view you could put criteria for the company field like
=Forms!NameOfClientsForm!NameOfTheCompanyControl

 

[Alastair]

Thanks Svetlana, much appreciated, it works like a dream!
Alastair