Re: drop down list within a query?

On Tue, 16 Jan 2007 11:48:00 -0800, Maax wrote:

ahh yes, that makes sense. i am in early stages (quite new to this) and was
trying to create all the queries before i created the forms.

many thanks

"fredg" wrote:

On Tue, 16 Jan 2007 11:05:00 -0800, Maax wrote:

hello all, is it possible to have a query present a drop down type of list?
The list would be for example a list of current customers (already defined in
a customer table). The list of current customers would be shown and the user
would select from the list and the results would be filtered accordingly.

any help appreciated.

No.
Create a form. Add the drop-down list to the form using the
CiustomerID and the CustomerName as columns.
Use the CustomerID field as the bound column of the combo.

In the query, as criteria on the CustomerID field, write:
Forms!FormName!ComboName

The form must be open when the query is run.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


What is the end stage of this?
Is it to display the query or is the query to be used as the record
source for a report?

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • Re: Re: Need some input on an Event Procedure for a search
    ... could try it with just needed a slight alteration to the SQL query. ... specific Features which some Customers would be looking for. ... The Customers table includes contact details, ... and the specific command for a mailout which is the event ...
    (microsoft.public.access.gettingstarted)
  • Re: Sum of numbers
    ... "Evi" wrote: ... You say the union query 'only shows fields from the first table'. ... Do you mean that you want a multicolumn report with all customers' names ...
    (microsoft.public.access.reports)
  • Re: I need a customer sales listing that includes no-sales months.
    ... > query of sales per month per customer, but I need the non-sales months ... > All my data is in one query called QryINVOICE. ... This sounds like a perfect candidate for a crosstab ... FROM (Customers INNER JOIN Orders ...
    (microsoft.public.access.queries)
  • Re: Sum of numbers
    ... Administrator to come in to insure we have this critical report by April. ... You say the union query 'only shows fields from the first table'. ... Do you mean that you want a multicolumn report with all customers' names ...
    (microsoft.public.access.reports)
  • Re: OO vs. RDB challenge
    ... Lets say you have a list of customers ... Layer 1. ... SQL might help with Layer 1 ... SQL might help with Layer 2 but only if the query is simple enough. ...
    (comp.object)