|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 15th, 2005, 06:16 AM
|
|||
|
|||
Combo box as a parameter
I have a table with a numeric ID and a text field. I want to write a query
where I can select a range of numeric ID's, but I'd like the user to see just the text fields. EG 1=buiding block 2=1 hectare 3=2 hectare 4=small farm 5=farm 6=rural land To query a property table, which stores only the 1 to 6 number, I'd like the parameter entry for the query to be a comb or list box for the "between [low combo] and [high combo] and use the numerics in the selection criteria. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| using combo box list item as query parameter | cindyb | Using Forms | 3 | May 15th, 2005 07:18 AM |
| Parameter query with combo doesn't work | GillianHG | Running & Setting Up Queries | 7 | January 11th, 2005 11:58 PM |
| Combo Box on subform prompts for parameter when it shouldn't Acces | Michelle Ives | Using Forms | 1 | July 15th, 2004 08:09 PM |
| using combo boxes to select parameter for SQL query | Dogbert Dilbert | General Discussion | 0 | June 16th, 2004 01:45 PM |
| Requery Combobox | MJ | Running & Setting Up Queries | 7 | May 25th, 2004 11:01 AM |
Linear Mode
