Re: Select a parameter for my query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Create a form that has a combobox on it that displays all of the names.

In your query, replace [Type last name, first name] in the criteria field
with Forms![MyForm]![MyCombo] (Use your actual names rather than MyForm and
MyCombo)

Note, however, that this will only work if the form is open when you run the
query. If it isn't, you'll get the same prompt you're used to, except it
won't have the helpful "Type last name, first name" instruction on it.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"LMB" <RomulanQueen@xxxxxxxxxxxxxxx> wrote in message
news:%23A8HxSLaFHA.4040@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Guys,
>
> Access 2000. I have a parameter query that I made. I have a field "Name"
> which is a concatenated field from a sub query. I put [Type last name,
> first name] in the criteria field. This gives me the results I want which
> is to only see one record instead of all the records. The problem is that
> I have to type the last name and first name exactly right with the comma
> and space for it to work. Is there a way to create a dropdown list of the
> names so the user can select the name instead of typing it in?
>
> Thanks,
> Linda
>


.

Relevant Pages

  • Re: Select a parameter for my query
    ... Thanks, Doug. ... > In your query, replace in the criteria field ... > Doug Steele, Microsoft Access MVP ... first name] in the criteria field. ...
    (microsoft.public.access.gettingstarted)
  • Re: Using combo-box selection to populate a SQL Function criteria
    ... Use the universal query in whatever query you want. ... what to put in the Function Criteria field that allows me to use the ... the function to help filter the report. ... warehouse or part data OR they can enter % as a wildcard to display ALL ...
    (microsoft.public.access.queries)
  • RE: make criteria look for a value on form
    ... "fossy" wrote: ... and then change your criteria in the query to ... I place the following on the criteria field of the “BtTitle” column of the ... I was hoping to make the field look at the form -> listbox to get the value. ...
    (microsoft.public.access.queries)
  • Re: Combo box populated from another combo box
    ... You need to be careful about doing this. ... "Alan Fisher" wrote in message ... > includes the table or query that you used on the first ... > and in the criteria field used the value of the first ...
    (microsoft.public.access.forms)
  • RE: make criteria look for a value on form
    ... text box on your form with its control source set to ... and then change your criteria in the query to ... I place the following on the criteria field of the “BtTitle” column of the ... I was hoping to make the field look at the form -> listbox to get the value. ...
    (microsoft.public.access.queries)