Can you use a combo box in a selct query



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: Using Filter by Form to create a Query and then a Report
    ... My thought was to use this same form and utilize the Filter By Form feature. ... If the data is what they want, they'll want a report from it. ... I want them to click a button that saves the filter as a query (query name ... It should prompt them for three things... ...
    (microsoft.public.access.queries)
  • Populate a List Box to select a record
    ... I use the same form to display different sets of records from a query that ... I limit or filter for different subsets by using the ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Desperate to filter main form
    ... now you can use this variable to filter your table by writing a query: ... now that query made a filtered table with only the results the user asked for. ... TraderAnalyst wrote: ... I get the prompt as stated above but it doesn't filter. ...
    (microsoft.public.access.forms)
  • Filter records in HTMLDB 2.0
    ... I have a query that can return a few hundred rows. ... way I can then apply a filter on top of that result set to display only a ... Canadian Forest Oil Ltd. ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • TransferSpreadsheet
    ... I'm trying to export data from a query to excel but I need the 'save as' ... dialog box to prompt the user for a file name. ... Prev by Date: ...
    (microsoft.public.access.externaldata)