It's easy enough to add All to the list:
http://www.mvps.org/access/forms/frm0043.htm
What's more difficult is making sense of interpreting it once you get it in
there.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
- Show quoted text -
Hi again,
After following the link and reading it over good, I guess your answer
is you cannot do this unless I assign some sort of UID or a choose a
different primary Key for this table?
For example, if your combo's RowSource is this SQL statement
"(AND IT IS)"
SELECT CustomerID, CompanyName FROM Customers ORDER BY CustomerID;
you can then easily add "(All)" as the first choice. Also, if
CustomerID is the bound field but it's width is set to zero (so that
the user only sees CompanyName), you can store a NULL (if the bound
field is not the primary key of the table), or someother value in the
bound field.
SELECT CustomerID, CompanyName FROM Customers UNION Select Null as
AllChoice , "(All)" as Bogus From Customers ORDER BY CustomerID;
tHIS WOULD WORK FINE IN THE EVENT ONE DIDNT HAVE THE PRIMARY KEY
ASSIGNED TO THE BOUND COLUMN. WHAT THIS DOESNT SHOW IS WHAT IF THE
BOUND COLUMN IS THE PRIMARY KEY WHICH IN THIS ISNSTANCE IS MOST LIKELY
TRUE MOST OF THE TIME. IS THERE ANY DOCUMENTATION ANYWHERE THAT WOULD
EXPLAIN THE WHAT IF?
THANKS,
DAVE
