Re: Can you use a combo box in a selct query

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

Put your combo box on a form and run your query from the form. The combobox
would then be the criteria:

Forms!YourFormName!YourComboBoxName

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



"Combo box and Queries" <Combo box and Queries@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message news:7B2BF943-E80F-4078-8D1F-10E60E24DA5B@xxxxxxxxxxxxxxxx
>I know when I build a query that I can prompt a user to answer a question,
> for ex. [Please list Last Name], which will filter the data. My question
> is,
> instead of the user entering the data can you have a combo box come up so
> they select the correct field. I want to do this so I can avoid people
> miss
> spelling things and then not getting the data they need. Thanks for the
> Help


.

Relevant Pages

  • Re: Queries with Many "or" criteria
    ... Thanks for the feedback! ... "Lynn Trapp" wrote: ... >>I am trying to create a query that will display all records except for ones ... >> that I have listed in the criteria. ...
    (microsoft.public.access.queries)
  • RE: Query with more than one criteria
    ... I ran the query you suggested and it works... ... In a nutshell, I want the user to enter a class, say 7.75G and a square foot ... say 752 and have Access calculate the total cost. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Can you use a combo box in a selct query
    ... If from a query, make it a SELECT ... The DISTINCT will take care of your dupes. ... > that it doesn't show duplicates. ... >>> instead of the user entering the data can you have a combo box come up so ...
    (microsoft.public.access.queries)
  • Re: Can you use a combo box in a selct query
    ... that it doesn't show duplicates. ... "Lynn Trapp" wrote: ... > Put your combo box on a form and run your query from the form. ... >> instead of the user entering the data can you have a combo box come up so ...
    (microsoft.public.access.queries)
  • RE: Filtering a subform using many combo boxes
    ... SELECT AssignedPriority, AssignedPriorityDetail FROM tblAssignedPriority ... YES for all of the combo boxes.) ... I followed you instructions to the letter and every one of the criteria ... open the query "qryProjects" in design view. ...
    (microsoft.public.access.forms)