Multiple use query

[Guest]

I have a database that is used to book meetings for different organisations
and in a few different places I use Combo boxes to allow choice of
organisation which then updates a second Combo box that shows the meetings
for that organisation. I then have a third Combo Box to select Members from
the organisation.

I populate the "Meeting" Combo box from a query that uses the "Organisation"
field on the form as the criteria.

I have to use a number of these queries as each one is called from a
different form and I wondered if there is a way to have a multiple use query
so that I have only one query that shows the meetings rather than one query
for every form!

Any help gratefully accepted!

 

[Jeff Boyce]

Why do you have multiple forms?

Jeff Boyce
<Access MVP>

 

[Guest]

They are for different things. For instance I have one form for entering and
editing the meeting details and I have another form to search for meeting
details.

 

[Jeff Boyce]

Wouldn't it be easier (and you'd get to use a single query) if you had a
single form that could do all three things (add, edit, search)?

I'm not aware of a way to use a single query with parameters found in
multiple forms.

On the other hand, if you forego the query and just use the SQL statement,
you could embed the SQL in each form, and customize it as needed.

Jeff Boyce
<Access MVP>