I'm looking for a way to add a wildcard ("*") to the top of a combo box. The other options that the user can select are taken from a table.
For example, I have a table of cars with three columns: Make, Year, and Model. On a form, I want two seperate combo boxes and a list box. The two combo boxes should be Make and Year, and the list should be Models. If I select Toyota and 1998 from the list boxes, I only want to see those models that are a toyota from 1998 in the list. If I select Toyota and *, I want to see all models that are toyotas, regardless of year. The combo boxes will pull in available makes and years from my table, but I need to know how to add the "*" to the beginning of each of their lists.
SELECT "dummyID" as PurposeID, "*" As PurposeOfProduct
Apparently Access doesn't care when it pulls data out of tables about data type conflicts. PurposeID is an autonumber (long) and as you can see "dummyID" is a string.
You'd have to pick some flag for your ID fields if you are using multi-column combo boxes. Since you're using it to drive code, rather than update tables, I think this is fine. Otherwise, you'd run into trouble if you had a Control Source specified for your box and it had a hidden primary key column expecting long values as a bases for pulling/updating/displaying recordset data.