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

Tech-Archive recommends: Fix windows errors by optimizing your registry

Combo box and Queries wrote:
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 

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Create a criteria form & run the query from the form.  Use form
references in the query instead of pop-up prompts.  E.g.:

SELECT *
FROM table_name
WHERE col_name = Forms!frmCriteria!ControlName

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQt6vG4echKqOuFEgEQL/cgCfRZtgLwfTTjCnLSAepAJIoxL5AZAAn1gW
gmuqI83jZuJkRBj5cxFe65+9
=N+Nq
-----END PGP SIGNATURE-----
.

Relevant Pages

  • RE: Searching Records
    ... Next, build a set of queries, one for each search ... the particular field the query will search on. ... design a form to display the output of one of the ... >> Selection, Filter by Form, and Apply Filter. ...
    (microsoft.public.access.gettingstarted)
  • Re: Creating a Search Engine with Access 2007
    ... In the horizontal scrollbar of a datasheet, you can type a value to find. ... You can right-click any field to filter it. ... Here's a downloadable example that shows you how to create a multi-field search, on different data types, for ranges and discrete values, full and partial matches: ... Internet) from data tables or queries. ...
    (microsoft.public.access.queries)
  • multiple types of queries and stored procedures
    ... What is the best practice for executing different types of queries with ... I've thought about using straight SQL rather than sprocs, ... a query builder class that could build the queries for me based on filter ... Business entity population - I currently populate my business entities ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Creating a search function on a table
    ... >I have a query that displays all the items I want off the customer table. ... > Now I want to filter the query on a new form that has a keyword search. ... > and then I have a text box that gets the key word. ... If queries are the way to achieve ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Clarified Question
    ... The subsequent queries reference those values to filter the ... The data entry form, frmDataEntry, is bound to the query ... If the second form is not editable, then it is likely because the queries it ...
    (microsoft.public.access.forms)