I am trying to create a way that I can add an option to 'Display All' in a combo box. I have found one way to do this using a Join query but am still having problems. The query works by adding an extra field called (All) that should represent all entries in the database, however it only rounds up those entries that are not null. This means I am missing many of my entries. This is the 'Join' query below. If anyone can offer any help on how I can get the (All) entry to actually include all entries as opposed to those that are not null I would be very grateful.
SELECT tbl_Interested.ProgID AS PID, tbl_Interested.Programmes AS Interested
UNION SELECT "*" AS PID, "(All)" AS Interested
ORDER BY Interested;
Sounds like you're confusing the listbox's RowSource property; you can either have a Table/Query, or a Value list, but not both. Although it is possible to create a recordset based on a query, run through all the results and create a value list based on a query (in which, you could then add an item like "(All)").
But I think the more important question is why would you want to? I'm assuming that this combo box is used to build a query? I usually just set it up that if the user doesn't make a selection, it's assumed to be all.