![]() |
|
|
#1
|
|||
|
|||
|
I am trying to narrow down records of students by subject code and time code. I have a parameter query that prompts users to enter the values. Is there anyway that I can have a combo box instead of having users enter the data themselves? Any help would be greatly appreciated.
|
|
#2
|
|||
|
|||
|
You can do this, but not directly in the query definition itself. You will have to design a form that will have the ComboBox. You could then use code behind the form to implement your selection criterion in a few different ways. For example, if you are ultimately displaying the info in a report, you can use the VBA code to dynamically set the report's data source SQL statement (the ComboBox selection would be used to define the WHERE clause).
I sometimes go one better by using a multiselect ListBox, and then use code to dynamically build the IN () statement I use in the WHERE clause. |
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Enter Parameter Value | plesser | Access | 1 | 11-08-2008 07:27 AM |
| Telling Query to Pull All Records by Combo Box | tigers | Forms | 1 | 04-28-2008 12:47 PM |
| How to create a query for logical combo?? | valkyry | Queries | 1 | 10-08-2007 12:32 PM |
| Pull Parameter Value from Form | dymondjack | Queries | 1 | 02-14-2007 04:15 PM |
| Date Parameter | shakira | Queries | 2 | 03-09-2006 09:55 AM |