Want to fill a list box with items from a table AND my own values

[ahmun]

I currently have a listbox that is populated with values from a table of City Regions (ie PDX, LAX, SFO, etc.)

I want to be able to list all the regions from the table, as well as include an "All" option.
I'm using this list box as selection criteria to filter a report.

Currently I have the listbox's

.rowsource

property set to an SQL query (generated by Access' Wizard):

SELECT [lkpRegions].[txtRegionID], [lkpRegions].[txtRegionName] FROM lkpRegions;

I've tried setting the listbox's

.RowSourceType

property to "Value List" and listing the values thus:
["All",

SELECT [lkpRegions].[txtRegionID], [lkpRegions].[txtRegionName] FROM lkpRegions;

- I want to keep all code within the form and the properties of the controls rather than create an actual query.
- And I don't want to include "All" as one of the regions in the table (or is this the easiest solution?)
- And I want to avoid simply typing in all the selections (in the case that more regions are added to the table, I don't have to update the form every time that happens)

Any ideas, anyone? Earnie Eng
Newbie Access Programmer/DBA
(I just got a job! yay!)

---------------------------------

If you are born once, you will die twice.
If you are born twice, [i

 

[930driver]

Use this as your rowsource:

SELECT [lkpRegions].[txtRegionID], [lkpRegions].[txtRegionName] FROM lkpRegions UNION Select "All" as Stuff From lkpRegions; "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[ahmun]

Thank you.

btw.. cool signature. I heard that quote in one of the DB classes I took recently Earnie Eng
Newbie Access Programmer/DBA
(I just got a job! yay!)

---------------------------------

If you are born once, you will die twice.
If you are born twice, [i